Forum Discussion
Solved
Row as header for different columns and different rows
Hello Experts,
For the below i want to make, for column 31 header should be 1st row and the remaining column header should be 2row how can i do it, If all are in same row i can use "use fitst row as header" but they are in different rows. Please help me experts.
This helped me.
3 Replies
This helped me.
Dear Universe24 please refer to the attached pbi and see how it's solved in M language.
https://drive.google.com/file/d/12kikF9Ps038k4SwTtdV42y8ibuYdSAxB/view?usp=share_link
let me know if you need any additional support.
Hi,
You can do this in power query:
- Promote the headers for the first row
- Add an Index column
- Duplicate the table
- Remove all columns except the Domain and Index in the first table
- In the duplicated table - Promote headers twice then add an Index column and remove the domain column
- Back in the first table - merge queries and select the column index to join on
- expand the rows and bring through the fields needed
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
