Hi, I have a spreadsheet and I'm bit stuck as to which formula (pivot table) to use to get the information out of my data table. I was thinking possibly Index/Match.

I'm a bit of a novice to Excel and couldn't get it to work. I've uploaded a workbook, first tab is data, second tab is what I'd like it to do.

Any help appreciated.

Seasons Greetings !

Attached Files

Data Query.xlsx (20.5 KB, 12 views)