Forum Discussion
Remov Reapeat and Transpse Data
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.
tnx
Jalal_1988 What do you mean? You ask for a PQ solution. You get one that is very basic. What other 'easy' solution do you want?
- i mean any other way for solve this problem have other solution for that
l feel you- Could you pease mention ste by ste which you done on file in power query
tnx1) 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.
Jalal_1988 Can't think of an easier solution right now.