Hello everyone
I'm trying to extract data from a table that has two layers of horizontal and vertical headings.
I know how to find a value using INDEX(MATCH,MATCH) if there is only 1 horizontal and vertical heading but am stumped with two!
Example data attached.
An example of a top layer horizontal heading would be 'Visits', with the layer below splitting this into country names.
An example of a top layer vertical heading would be '2013|45' (year and week), with the layer below splitting this down to source type (i.e. email, organic, etc).
Unfortunately I'm not able to adjust the layout of the source data as it is exported from Google Analytics using an export tool.
I want to be able to MATCH the first layer then the second, i.e. provide the value for 'Pagviews' from 'United States', for week '2013|45' from 'Organic' only.
Appreciate any help!
Bookmarks