Forum Discussion
HennSarv
3 years agoHelper I
taking two (2) first line as column headers
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
Hi,
transpose your table
then merge the columnsthen transpose again and promote the headers
Hope that works!