Forum Discussion
gabriellamccormick
Aug 13, 2024Copper Contributor
Transposing Data
Hello! I have a data set that has an general ledger code that is vertical and an entity code that is horizontal. The table will have an amount that relates to a certain general ledger account for...
Patrick2788
Aug 13, 2024Silver Contributor
You can do this by unpivoting with PowerQuery.
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098