taking two (2) first line as column headers

[HennSarv]

Dear friends - help me bypass some manual work

I have data source (I can't change) containing tables (actually sheet but can treat as Excel

Thei contain several tables, where header contains in two (2) rows so I need to combine 2 rows into one, bes when I can to concat them. So I'm looking something like 

Reocord.ConcatByMember({table{0},table{1}})

Name, Address, Salary, Salary, Slary
null, null, 2020, 2021, 2022

->
Name, Address, Salary 2020, Salary 2021, Salary 2022

PS! Actual number of columns is much biger but somekind ligic is similar

[olgad · Accepted solution]

Hi, 
transpose your table

then merge the columns

then transpose again and promote the headers

Hope that works!

[HennSarv]

Great!

TUhat tänu!
Many (100) thänks!
Grazie mille!