Excel transpose and merge

Question

Does anyone know a function or method in excel of getting data in a state from Illustration 1 to Illustration 2. Transform could be part of the solution but I need a way to consolidate rows and columns at the same time

sergeibaklan · Answer

clieboff&nbsp;
Power Query could help

clieboff · Answer

cool. I've never used before. do you happen to know how that could work and the steps?

sergeibaklan · Answer

clieboff&nbsp;
Sure, if only you share sample file instead of screenshot

clieboff · Answer

i updated my post to include. much appreciated.

riny_van_eekelen · Answer

clieboff&nbsp;How about a pivot table? See attached.

Forum Discussion

Excel transpose and merge

8 Replies

Resources