cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
zmukadam Frequent Visitor
Frequent Visitor

Find text in column header and adding in to a row

Hi,

 

So I have two sets of data, they are for two separate accounts. What I want is that a user can filter on the account and get shown the data from that account. How can I do this? The only way you can see its from a different account is by looking at the header as it says the account name. I want to create another column which will pull only the account name into a row.

1 REPLY 1
affan Established Member
Established Member

Re: Find text in column header and adding in to a row

Hi @zmukadam ,

 

You can user the Power Query editor to do the Unpivot the columns so you get the headers in rows.

 

However if you can share you sample data tables and expected results, it will help understanding your issue better

 

Regards

Affan