Forum Discussion
Solved
transpose multiple date columns into rows
Hi, My current table looks like this where I have dates as column headers. I would like to transpose the date columns into rows and thus transpose the data in each of the date columns as well. Secon...
- Hi saipawar,
On the query editor select all the columns you needs to transpose and make the unpivot that will give you the resultthat you expect.
Check documentation below:
https://support.office.com/en-us/article/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
