I have sheet Result and want to get data from sheet Source. Pls help to show me how can I get data as image following.

Tks you so much !

CodePudding user response：

First option:

Un-merge the cell in source sheet and instead of "Detail", type meaningful column names to B1 to F1.

Then select your data and create a pivot table (pls do some google if you need to).

Play with pivot table until you reach the view you want (it is possible to get the same view as the result sheet you shared.)

Second option as you requested:

Insert a new column after column A in your source (between abs and roma).

Type this formula in this new column: =A2&H2.

Then type this formula in Result sheet B2: =Vlookup($A2&"2";Source!$B$2:$G$13;3;false)

Copy this to other cells. Do not forget to update parameters for other cells.