Please Help with simple transformation.. I forgot what this is called

Hey all,

My client had a spreadsheet with Column A = department and column B = process name.. In column C, D, E, if that process (column B) had additional sub processes, they would be listing horizontally, next to its respective process name.

What I want to do is ONLY have column A and B, but everything in C, D, E I want to be bunched in with column B.

So if a process (column B) = “Accounts payable” & in Column A it says it belongs to finance, I want anything that’s next to “Accounts payable” (column c, d, and e) to be placed in column B marked as “Finance” for department, as if they’re all related and bunched together.

I know there’s an easy way to do this in the query editor / PQ. Can someone please connect the dots for me here? Or at least give me the word I need?

Seems like along the lines of pivot/unpivot/transpose family of transformation..

Sorry for this poorly explained request - If anyone can help, please reach out.