Forum Discussion
Solved
Remov Reapeat and Transpse Data
Hello my friends I want in power query to remove the repeated rows and transpose the invoices like i showed in excel file , thank you fry your help
Jalal_1988 I trust you have a good reason for wanting to do this, since the data is already very well structured as it is. One would normally want to go from the 'transposed' data towards data in a tabular form. But that's your choice.
See attached.
i mean any other way for solve this problem have other solution for that
l feel you
l feel you
Could you pease mention ste by ste which you done on file in power query
tnx
tnx
1) Connect to the data range
2) Promote headers
3) Group by CODE and Name. I chose 'Sum by INVOICE' first. That creates an error as you can't sum texts. But it gives you 90% of the M-code needed.
4) Manually change the initial code for the "Grouped Rows" step into:
5) Add an index column to number the two rows and sort/reorder the columns as you like.