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.
exp vgAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Robert ShermanOwnerCommented:
Can you give us a little more info on why you think you need to do this?  

I can't immediately see any reason to need this in Access.   Where Excel sheets are pretty much open-ended rows and columns of cells with no set definition necessary, Access is a structured database where a row is always going to be one record of data and each record contains its actual data fields in columns.

Thus my reason for asking for some background info..
exp vgAuthor Commented:
I am working on creating an automated system for people other than myself, so the less steps they have to do the better.

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.
Kanti PrasadCommented:
Hi

Create a new table to hold the transposed data so look Method 2 - Use a Custom Function to Transpose the Table

https://support.microsoft.com/en-us/kb/202176

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
exp vgAuthor Commented:
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.
Kanti PrasadCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.