Register
Log In
Unanswered
Home
New Member
Power Query
Power Pivot
Power BI
February 22, 2017
Offline
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.
July 16, 2010
Offline
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
Most Users Ever Online: 57
Currently Online:
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
