Forum Discussion

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...

Tips and Tricks

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

Super User

4 years ago

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