Forum Discussion
Excel Help Taking a Sheet with Multiple Breaks and turning it into a flattened version
Taffalaffa Since you intend to work in PowerBI, use its Power Query (PQ) function to transform the data for you.
Connect to the REGIONAL file on your system and perform a few simple steps t create the table you need. The attached file is based on your Test Sheet. All you need to do is point the Source step to the correct location and file.
The table in the Query tab is the end result.
Taffalaffa Since you intend to work in PowerBI, use its Power Query (PQ) function to transform the data for you.
Connect to the REGIONAL file on your system and perform a few simple steps t create the table you need. The attached file is based on your Test Sheet. All you need to do is point the Source step to the correct location and file.
The table in the Query tab is the end result.
Riny_van_Eekelen This is fantastic! Exactly what I needed. Thank you so much for the help!
