Multiple Tabs - Data combine
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
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.
The data fills in landscape across the columns instead of row after row
as it was input.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1