Find text in column header and adding in to a row

[zmukadam]

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.

[affan]

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