Extract data from a Table

Guys,

I have a table containing the data of audits of companies by Rating Agencies (in last 03 years). My boss asks summaries of these audits. I attached the table and the summery report format.

Can u guys help me to do this?

AttachmentSize
Book1.xlsx13.63 KB
akmughal's picture

Hi, I prepared sheet for you,

Hi,
I prepared sheet for you, what I did
1) create list of your desired company names
2) Normalize your detail data in columns and rows (didn't change any thing)
3) create a unique identifier which help to pick the values from detail table
4) create vlookup in your summary sheet to pick up your desired information from detail table.
I don't know how to attach a excel sheet here. Share with me your email id I will forward you then, hopefully it works.
Thanks