Rearrange various tables
Posted by lex on September 15, 2000 7:24 AM
I have various reporting tables in formats such as
Jan Feb Mar Apr
AREA1 1 2 3 4
AREA2 2 4 5 6
AREA3 5 6 7 8
which I need to convert to the format
Area1 Jan 1
Area1 Feb 2
Area1 Mar 3
Area1 Apr 4
Area2 Jan 2
Area2 Feb 4
etc.
Any ideas? Even with variations on Vlookup, IndexMatch , Transpose etc I have fallen over on this one so any help would be very helpful. - many thanks!