Forum Discussion

padinator's avatar
padinator
Helper I
4 years ago
Solved

Dynamically rearrange rows into one Header column in Power Query

Hello, i have been looking for a viable solution quite some time but unfortunately did not find something appropriate so I have to come and ask you guys. The situation is as follows - I have a table...
Need Help
Show and Tell
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi padinator ,

     

    Have you tried selecting all of your [Header X] columns and using the Fill Down function on the Transform tab?

    This assumes that none of the value cells in these columns will be null.

     

     

    Pete

padinator's avatar
padinator
Helper I
4 years ago

Well yes - this was quite the solution - what i did was to Mark the FIRST Columns A-J and FillDown since the cells underneath where "nulls" so that i have all Column Headers in one single Row - then i used this Row as Header Row - I deleted the other 2 Top Rows so that i get a table with Header A - J following one Header Column per calendar week and finally unpivot the table using (Other) Thanks for this hint