this question may have been asked many times but I cant get my data work with the sample queries I found on different sites,
I have a challenge which I need to pivot my table /date,
my data looks like below;
ID Business Date Value 1 GPS Nov-18 3 2 GPS Dec-18 2 3 GPS Nov-18 2 4 GPS Dec-18 3
and my aim is to have a out put like below;
ID Business Nov-18 Dec-18 1 GPS 3 2 2 GPS 2 3
I appreciates any help, if you let me know the syntax and way I should apply to query.