excel

[raadwiptec]

I have the following input source in Excel format. Iam looking to transpose it but not getting the correct format. So here i have the Month

07 in the first header line.. rest of the header lines on the first line is empty

							07	07	07
Flag	Invoicecode	InvoiceNumber	CustomerName	Product	Product description	Year	Final Qty	Final price	Final value
N	2100877	132566		Product1		2017	650.000	€                 0,11	€ 68.886,00
Y	2100856	132587		Product2		2017	550.000	€                 0,11	€ 58.886,00

Any sugg

[Frank_Hartmann · Accepted solution]

Hi raadwiptec,

have a look at the attached qvw!

I adapted rbechers really nice solution from this post Re: Transpose to your excelfile.

Hope this helps!

[Frank_Hartmann]

Did this solve your problem?

If yes, then please close the thread by marking correct and helpful answers!

If not, please let us know the problems you are facing .....

[raadwiptec]

hi frank man thanks indeed for your help