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

[Anonymous]

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.

[V-pazhen-msft · Accepted solution]

@Anonymous 
You can just selected the columns =>right click =>select merge columns = change the column name to Finance.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[ponnusamy]

@Anonymous : Check the following post

https://community.powerbi.com/t5/Power-Query/Agregar-filas-en-una-tabla-en-base-a-valores-en-la-columnas/m-p/2143974#M63333

[HotChilli]

Are you trying to unpivot the other columns apart from the first two?

Some sample data and desired output would help.