Fill right process with formula


Can anybody help me to find one process to fill right with formula. See screen below

I want to fill right the row AKZ_KRIS with one concatenation from KOMMENTAR row, for exemple 88AB23 need to be inserted in row 1 colum4

Thanks for Helping

  1. Delete the 1st row (“AKZ_KRIS”) using the “Trim table” action.
  2. Extract the KOMMENTAR rows into a separate derived table using a filter.
  3. Replace “KOMMENTAR” with “AKZ_KRIS” in that table.
  4. Append the derived table as 1st row using the “Append tables” action.
1 Like