Merge text from to lines to one line

I would like a column that combines the text from the ‘Description’ where there is a value in ‘quantity’ and from the line without ‘quantity,’ effectively merging the ‘Description’ from two rows.
For instance a new column containg both "BigBank omlegging" and "18.01.2024, Matthew..."

Hi Jørgen,

You can use the "Shift columns" action to bring every 2nd line up one line and append it to the description in the line above. See the example below:

append 2nd line.morph (3.6 KB)

Ahh, genius :slight_smile:
Thank you, perfect result!


You're welcome :slight_smile: