yogi_Rearrange Tabular Data CrossTab Lead Name And Rating By Category

Google Spreadsheet   Post  #2292

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-16-2017

question by: AJ Tabuena

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/XP_Hv6kGPT8;context-place=forum/docs

Match values in cells in column A, B, C and output C in another cell

Hoping someone could help with this, been racking my head trying to figure it out. This is what I have:

| Header | Column A | Column B | Column C | 
| Row 1  |    ABC   |    AAA   |     4    |
| Row 2  |    ABC   |    BBB   |     3    |
| Row 3  |    ABC   |    CCC   |     4    |
| Row 4  |    DEF   |    AAA   |     2    |
| Row 5  |    DEF   |    BBB   |     3    |
| Row 6  |    DEF   |    CCC   |     4    |

What I'm looking to accomplish is that when A and B match, it outputs C so that I can create a new table that looks like this:

| Header | AAA | BBB | CCC | 
|  ABC   |  4  |  3  |  4  |
|  DEF   |  2  |  3  |  4  |

So essentially, I would need formulas so that I can automate the numbers under the headers AAA, BBB, CCC. I really hope someone can help as I've been looking for a way to do this using INDEX and MATCH but nothing seems to work right.

Here's an example sheet of the sample and my desired result.