Break Up A Spreadsheet

's Computer Specifications

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.

's Computer Specifications

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

"Ron Mc." wrote:

> 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.

's Computer Specifications

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

"Ron Mc." wrote:

> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subtotal-new spreadsheet at each break?	DRayner	Microsoft Excel Worksheet Functions	1	8th Feb 2008 12:35 AM
unable to delete page break on Excel spreadsheet	=?Utf-8?B?c29uanN1bGw=?=	Microsoft Excel Worksheet Functions	1	3rd Jun 2006 07:16 PM
Adding a page break to a Word doc with an Excel spreadsheet linked	=?Utf-8?B?Rw==?=	Microsoft Word Document Management	2	21st Feb 2006 05:14 PM
How can I break link to a spreadsheet that doesn't exist?	=?Utf-8?B?WmUnZXY=?=	Microsoft Excel Crashes	0	14th Jun 2005 08:20 PM
Break Link to spreadsheet	=?Utf-8?B?cndhdjE=?=	Microsoft Excel New Users	1	18th Aug 2004 08:03 PM