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?

Sample data -.xlsx