Ok, this is driving me mad. I feel I should know the answer but I've
tried various combinations of lookups, indirects, offsets etc and I
just can't figure it out!

I have a list of data:


AAA
Jan 15
Feb 20
Mar 25

BBB
Jan 100
Feb 120
Mar 130

....and this goes on somewhat. I want to set up a new table like so:

Jan Feb Mar
AAA
BBB

....and populate it with the data from the first table. I can of course
do it with lookups but I have to change the range for each line. I
want to use one formula that I can just copy to all cells and it will
give the appropriate value. How???