Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tony Williams
 
Posts: n/a
Default Making Rows into Columns

I have a spread sheet where the user enters data as:
Column 1 Column 2
Row 1 Company Name ABC Ltd
Row 2 Turnover 1000000
Row 3 Profit 10000

How can I turn that into
Column 1 Column 2 Column
Row 1 Company Name Turnover Profit
Row 2 ABC Ltd 1000000 10000

I ma trying to find a way to let the users key data vertically but change
the data to horizontal so that I can export it into an Access database,
Access wont look at columns for field names. I have 50 fields so a
horizontal spread sheet would be cumbersome. I am new at Excel but
reasonably ok on Access
TIA
Tony Williams



  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Tony

I would simply use copy / paste special transpose
1) select all your data
2) choose copy
3) click on cell A1 of a new worksheet
4) edit / paste special - transpose
5) fix up column widths

Cheers
julieD

"Tony Williams" wrote in message
...
I have a spread sheet where the user enters data as:
Column 1 Column 2
Row 1 Company Name ABC Ltd
Row 2 Turnover 1000000
Row 3 Profit 10000

How can I turn that into
Column 1 Column 2 Column
Row 1 Company Name Turnover Profit
Row 2 ABC Ltd 1000000 10000

I ma trying to find a way to let the users key data vertically but change
the data to horizontal so that I can export it into an Access database,
Access wont look at columns for field names. I have 50 fields so a
horizontal spread sheet would be cumbersome. I am new at Excel but
reasonably ok on Access
TIA
Tony Williams





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 07:00 PM
Printing multiple columns on one page tdj Excel Discussion (Misc queries) 4 December 2nd 04 03:55 AM
Blank Rows Acesmith Excel Discussion (Misc queries) 1 November 30th 04 10:23 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 30th 04 12:56 AM
Filtering rows with tracked changes Kiwi Mike Excel Discussion (Misc queries) 0 November 28th 04 12:50 AM


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"