Transpose rows to columns

  • Thread starter Thread starter Mansoor
  • Start date Start date
M

Mansoor

I have a table imported from excel with 10 columns and 25 rows and I would
like to transform rows in columns:

from
A1 A2 A3 A4 A5
B1 B2 B3 B4 B5
etc .......

to:
A1 B1
A2 B2
A3 B3
etc .......
Thanks in advance
 
I don't understand why your values are
A1 A2 A3 A4 A5
B1 B2 B3 B4 B5
I would expect the Excel to look like
1A 1B 1C 1D 1E
2A 2B 2C 2D 2E

Do you have actual table and column names you could share?

Generally the solution involves creating a union query and then a crosstab.
 
I have a table imported from excel with 10 columns and 25 rows and I would
like to transform rows in columns:

from
A1 A2 A3 A4 A5
B1 B2 B3 B4 B5
etc .......

to:
A1 B1
A2 B2
A3 B3
etc .......
Thanks in advance
Click to expand...

It's probably easier to do the transposing in Excel (with Paste Special...
Transpose and/or the TRANSPOSE spreadsheet operator) and *then* import into
Access.
 
John W. Vinson said:
It's probably easier to do the transposing in Excel (with Paste Special...
Transpose and/or the TRANSPOSE spreadsheet operator) and *then* import into
Access.
Click to expand...
Thank you Vinson, it worked
 
Back
Top