Click here to Skip to main content
15,749,184 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have data which is saved in the form of

id  day  batch
1  Nov1  A
2  Nov2  B
3  Nov3  A
4  Nov4  C
5  Nov1  B
6  Nov2  A

I want to show it in the form of

Nov1 Nov2 Nov3 Nov4
A    B    A    C
B    A

It mean my rows and columns are dynamic as no of days are not limited same as no of batches also increased
In pivot how i transpose it thanks

Share this answer
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900