need formula to arrange the data from columns to Rows

Hi Team,

I have given my data in the attached spread sheet. Please assist me in getting the final result as highlighted under "What I need is" using formula or Macros using the actual data given in A and B column. Kindly do the needful.

Regards,
Girish

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Hi Giri,

In H3 put this array formula and pull it over and down. You also need to add a Counter column. See the attached

=INDEX($B$1:$B$11,MATCH($G3&H$2,$A$1:$A$11&$C$1:$C$11,0))

CSE two match Index.xlsx

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Try

G3

Formula:

Please Login or Register  to view this content.

copy down.

H3

Formula:

Please Login or Register  to view this content.

Copy across H3:K5