Hi guys,
I am trying to transform or extract data from the table below and get it in my desired form shown in the image below that. Is there anyway to use VLookup or Index/Match to do this? My data set is gigantic so I cannot do this by hand. Ultimately this data will go to sas.
Current state of data:
pivot 1.png
Desired outcome of data:
pivot 2.png
Bookmarks