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