Making Rows into Columns

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

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

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

Text to columns 2
How to make an absolute reference to an excel 2007 table column 1
convert columns to rows 6
conditional formatting referencing 3 cells by row in a range 3
Help with formula 3
I want to take select cells from other rows (2 and 3) and combinethem with row 1 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Lookup to create List 3

Back
Top