PDA

View Full Version : Copy several cells into one cell



kiisaaa
08-28-2018, 01:17 AM
Hi,

I am currently trying to clean up a sheet of data with 1200 rows sorted by Area -> Process -> Sub-process -> Activities.
I want to categorize these activities by sub-processes only with the activities listed in one cell instead of several rows.
Please see my example file.

Can anyone help me?? Either by a smart way of doing the copy-paste, or by some other way?

22781