Excel Offset Match Match - Help

Hi guys, long time reader - first time poster.

I am having trouble searching & matching in an array in Excel - from what I read, I think OFFSET with nested MATCH's should do the job, I just can't wrap my head around how to do it.

The output table has the following form:

	Date1	Date2
a	X	Y
b	Z	M
c	...	...
d	...	...
e	...	...
f	...	...

So I am looking for X, Y, Z, M etc....using offset match in those cells.

The table that holds the data is where it is tricky. And it comes from another source, so I can't easily manipulate it. It looks as follows:

a	BBG	b	BBG	c	BBG
Date1	X	Date1	Z	Date1	#
Date2	Y	Date2	M	Date2	#
Date3	#	Date3	#	Date3	#

So for each security (a,b,c...) there are two columns...the first that holds the date and the 2nd column has the data (all the #'s) I'm looking to have in the output table as X,Y,Z. There are no blank columns, its always "a" followed by BBG (which is just the heading of the data identifier - it can be blank if not needed) then the next security "b" and so on... Not sure what the easiest way to search through would be.

I hope this is clear; appreciate the help.