Mysql pivot query rows and column

See more:

C#

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