I am having the table where data with the same invoice number stored as shown in table 2 and I would like to display it as shown in table2
invoiceno amnt month 123 77 jan 453 89 feb 123 65 april 321 34 jan 321 44 feb 453 87 mar 321 45 may
invoice amnt1 amnt2 amnt3 123 77 65
321 34 44 45 453 89 87
I used the pivot table query but didnt worked can someone please help me