Merge Rows if value in one column is empty

[lesoies]

I am looking to merge a row with the row directly above it if that row has a blank cell in a specific column (e.g. if Column A if blank, merge entire row with one above it).

Attached is a spreadsheet with before and after sheets. Any ideas?

Thanks.

[HaHoBe]

Hi, lesoies,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[lesoies]

Outstanding. Exactly what I was looking for. Thanks.