Transforming Data Set

Hello everyone,

I need some help transforming a data set into a specific way. I've attached the excel file and tab called "Data" is what the original data set looks like. I need to transform the data to look like tab "Result".

Please notice that in "Data", SiteID and GPID eventually change. I think this job requires some index match match but I'm not 100% sure.

Can someone help me out?

This is an array formula so enter with ctrl + shift + enter
Put this formula in cell E2 and then drag down and across.
What i did notice is that column E and G came back "N/A" due to your titles in row 1 for those columns not matching anything on the Data tab.

Formula:

Please Login or Register  to view this content.

This worked - thank you very much dosydos