Change Column unique id as the Company id changes

[tworemi1]

I have a table from a company that has a unique company id. Column 6 from the from this company table has a unique column identifier. When i then change the company id to new company, column 6 reads the unique column identifier from the previous company. I want to use power query to make column 6 to automatically change the unique column identifier based on the change in unique company id.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[tworemi1]

The pictures that i sent summarises my problem. I want to find a way in which i can automate the process of copying the column header from the Responses table to column 19 row 3 of the Responses v2 table. The reason being the unique identifier changes automatically when the survey id changes in the Responses table but refuses to change in the Responses v2 table thus giving us an error.

[dufoq3]

Could you please provide sample of both tables (either as table or upload somewhere as an excel file and share the link with public rights with us) and also the query with issue.

[tworemi1]

[lbendlin]

Responses v2 is in usable format. Responses needs to be unpivoted.