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

"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