exp vg
asked on
Access - Similar to Excel - Paste Special Transpose
Hello
In Excel this transpose of a table is easy. Please offer a query way I can transpose a table in Access as well.
Thank you.
In Excel this transpose of a table is easy. Please offer a query way I can transpose a table in Access as well.
Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, i came across this in my research as well. What i am looking for is if this is possible in an Access query.
Thank you.
Thank you.
Hi
Please see if this helps
TRANSFORM Table1.Column3
SELECT Table1.Column1
FROM Table1
GROUP BY Table1.Column1
PIVOT Table1_1.Column2;
This will transpose Column2 using Column1 ids i.e for each column1 id it will look in Column2 and transpose it
Column1 | Column2 | Column3
--------------------------
11 | Value1 | 1
11 | Value2 | 2
11 | Value3 | 3
Column1_ID | Value1 | Value2 | Value3
11 | 1 | 2 | 3
Please see if this helps
TRANSFORM Table1.Column3
SELECT Table1.Column1
FROM Table1
GROUP BY Table1.Column1
PIVOT Table1_1.Column2;
This will transpose Column2 using Column1 ids i.e for each column1 id it will look in Column2 and transpose it
Column1 | Column2 | Column3
--------------------------
11 | Value1 | 1
11 | Value2 | 2
11 | Value3 | 3
Column1_ID | Value1 | Value2 | Value3
11 | 1 | 2 | 3
ASKER
If I can create all of these queries in Access itself, and export it to excel in as near to final format, the easier it will be on them.
Thanks.