Forum Discussion
Jalal_1988
Dec 23, 2023Brass Contributor
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
- Dec 23, 2023
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.
Riny_van_Eekelen
Dec 23, 2023Platinum Contributor
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.
- Jalal_1988Dec 23, 2023Brass ContributorDear fiend is there any other easy solution for that ?
tnx- Riny_van_EekelenDec 23, 2023Platinum Contributor
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?
- Jalal_1988Dec 23, 2023Brass Contributori mean any other way for solve this problem have other solution for that
l feel you