Notifications
Clear all
Topic starter
How can I promote several rows as a header when loading an excel/csv file to power query? (if possible without M). I usually have to work with big data-sets where units must be specified.
Posted : 25/02/2017 1:53 am
Hi Nuja,
Format your Excel data in a Table. Note: make sure when you create the Table from your data in Excel that you do not check the 'My data has headers' box.
In Power Query you then have to transpose the data > merge the two columns containing the headers together into a single column > then transpose again and finally you can promote the headers.
Mynda
Posted : 25/02/2017 8:02 am
Topic starter
Thanks Mynda
Posted : 28/02/2017 3:43 am
