Break Up A Spreadsheet

G

Guest

I'm rather a novice at Excel but hopefully someone else here has already done
this. I have a spreadsheet with approx. 500 rows and 30+ columns. Is there
a way to take that spreadsheet and break it into multiple spreadsheets, with
each row on a

from:

Column A Column B Column C etc.

to:
Column A Header Column A Value
Column B Header Column B Value
Column C Header Column C Value
etc.
 
G

Guest

Hi Ron,

If I understand you question correctly, you should be able to select all the
data on the worksheet then Copy.

Select another blank worksheet and select the top left cell (A1) and then
Paste Special->Transpose->OK.

Regards,

OssieMac
 
G

Guest

Hi again Ron,

If using pre xl2007 version then you only have max 256 columns so it will
not fit 400 rows of data for transpose. No problem with xl2007.

Regards,

OssieMac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer array element offset value to a matched value 3
Excel 2013 Merge Data 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Comparing numbers 1
Excel - Macro to rearrange/add columns in all the sheets based oncolumn header 10
VBA - Run same logic on values in columns 2 & 3 0
Some trouble assigning a string to a variable 22
Increment a row based on another column with duplicates possible 1

Top