How to rename column headers taking new header values from row?

[cgkas]

Hello to all,

May someone help me to do this?

I have more than 120 columns with headers like Column1, Column2,...ColumnN.

I want to rename the first 10 headers with values in Row6 from column 1 to 10 and rename the rest of headers with values in row 9 from column 11 to colum 120.

Can be done with a kind of loop or only using a hardcoded list within Table.TransformColumnNames(List)?

Thanks for any help

[parry2k]

@cgkas seems like i have a solution for this but would like to know what happens to row 6 and row 9, it still stays there, right, even thou the value from these rows becomes header.

[parry2k]

@cgkas here is how it looks like on my sample dataset

[cgkas]

Hi @parry2k ,

Actually, after rename the original headers I'd like to remove rows 1 to 9. So will remain new headers and rows 10 to the end.

Thanks for the help

[parry2k · Accepted solution]

@cgkas solution is attached, you can tweak it as per your needs.

[cgkas]

Thanks so much @parry2k  for your help. It works pretty nice!