I have a spreadsheet that has multiple tabs with the same data on each
tab. The data is input line after line. Example appears below

Name : John Smith
Address : 123 Main Street
City: Anytown
State: Ca.
Zip: 12345

I need to gather the data from each tab and put it into a columnar
format
that looks like this

Name Address City State
Zip
John Smith 123 Main Street Anytown Ca 12345

Basically the data ends up fitting nicely into columns instead of
rows.

I can then make a relational database out of the data. I have tried
the
=(cell#) and have tried to make the cells absolute on the reference
but
it does not work.

Any help would be appreciated.

Thanks,

Damion


--
zero760
------------------------------------------------------------------------
zero760's Profile: http://www.excelforum.com/member.php...o&userid=26800
View this thread: http://www.excelforum.com/showthread...hreadid=400545