Ramco Ramco

Ramco Ramco

  • 1k
  • 1.6k
  • 132.5k

How to create Pivot of below Data

Oct 30 2022 7:42 AM

Hi

  I have below excel Data & i want to display it like below. Entry Type is Dynamic . Tomorrow there can be more like Purchase,Sale

BookID	EntryType	Quantity
1	Opening	        6
2	Opening	        8
1	Dispatch	   -1
1	Dispatch	   -1
1	Dispatch	   -1
1	Dispatch	   -1
2	Dispatch	   -1
1	Dispatch	   -1
1	Dispatch	   -1
2	Dispatch	   -1
1	Dispatch	   -1
1	Dispatch	   -1
1	Dispatch	   -1
1	Return	        1
2	Return	        1
1	Return	        1
1	Return	        1
2	Return	        1
1	Return	        1

I want to display Data like below. In case tomorrow there is entry of Purchase/Sale that coloumn should dynamically get add.

Book       Opening           Dispatch          Return        

1                 6                       9                   4

2                  8                      2                   2

Thanks


Answers (1)