Merge multiple rows into one based on common column values

[Yoichi]

HI,

The following is grouping by column “Booking No”,“Booking Component ID”, “Item No” and “Booking Status” and concatenate string in “note” column. In remaining column, the first row is kept. Does this work for you?
Or do you need grouping by all the columns except “note” column?

Sample20230210-4Lv2.zip (21.2 KB)

Regards,