Forum Discussion

HennSarv's avatar
HennSarv
Helper I
3 years ago
Solved

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 columns

    then transpose again and promote the headers

     

    Hope that works!

2 Replies

  • olgad's avatar
    olgad
    Resident Rockstar

    Hi, 
    transpose your table


    then merge the columns

    then transpose again and promote the headers

     

    Hope that works!

    • HennSarv's avatar
      HennSarv
      Helper I

      Great!

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