Transpose rows to columns

[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

 

[golfinray]

Use a crosstab query.

 

[Duane Hookom]

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.

 

[John W. Vinson]

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

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.

 

[Mansoor]

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.

Thank you Vinson, it worked