How To Concatenate multiple non blank cells contents into adjacent column skipping intermediary blan-CodePudding

Home > Mobile > How To Concatenate multiple non blank cells contents into adjacent column skipping intermediary blan

How To Concatenate multiple non blank cells contents into adjacent column skipping intermediary blan

Time：10-29

I'm facing this problem:

In Column C I need to:

concatenate each vertical non-blank cells groups from Column A (ignoring the blank cells groups in between) AND,
only concatenate them once (no duplicate smaller groups in-between) AND,
skip "mono-cell" instances.

Problem Illustration:

Text Table for easy copying:

(