I have data in one format:

Jan Feb
CoA 10 20
CoB 30 40

I want to be able to do a lookup to get it to look like:
CoA CoB
Jan 10 30
Feb 20 40

I tried doing an index with embedded matches, but that didn't work -- Does
anyone have any suggestions?

I don't want to do a copy-paste values-transpose because it's going to be
something I'm going to need to update on a daily basis and want to be able to
trace back where my numbers are coming from.

Any help would be appreciated.

thx.