pivot

[Saravanan_Desingh]

Try this,

tab1:
LOAD SNO, 
     [INVOICE NO], 
     [GENERATED DATE], 
     MONTH, 
     AMOUNT
FROM
[..\Mis_Test_Srini (1).xlsx]
(ooxml, embedded labels, header is 1 lines, table is Task1);

Dim: INVOICE NO & MONTH

Exp: Sum(AMOUNT)