to join columns

[vis65]

Hello everybody,



I have a table with 9 columns and 4 rows as I show on the following picture.



I would like a query to join the columns with the same field as I show on the following picture.



I have windows 7 and access 2013

Thank you so much.

[orange]

Are you trying to redesign your table?
You table is not normalized.
see this link for more info on Normalization
Good luck.

[Micron]

Weird. My post just seemed to vanish. I said the same, plus that spaces in field names are a no-no if the sample is accurate. If there are no spaces, you're just making it more difficult to provide example sql statements.

Also said that you'd have to use a UNION query

SELECT [Item 1] As Item, [Price 1] As Price, [Units 1] As Units FROM tblSomeTable
UNION ALL
SELECT [Item 2], [Price 2], [Units 2] FROM tblSomeTable
UNION ALL
SELECT [Item 3], [Price 3], [Units 3] FROM tblSomeTable;

[ranman256]

your table is designed wrong.
you only need 3 columns
ITEM, PRICE, UNITS

so make 3 queries to add them to the redesigned table.
q1 = 1st 3 coluims
Q2 = 2nd 3 columns
etc

[vis65]

Thank you Orange (Moderator) for the valuable information about the website of Roger (It is a blog very useful) and specially thank you to Micron for the code, it works perfectly. Also I would like to say that my database has a lot of spaces because I have imported it from an excel spreadsheet.
And in response to Ranman256, that’s true that I only need 3 columns, but I got automatically this information with this design from an Excel spreadsheet, but thank you anyway for your observation ;-)

Thank you so much to everybody!

[Micron]

Ok, just figured out that my post was actually in an Excel forum, which means this is cross posted here
http://www.mrexcel.com/forum/microso...ml#post4670114

vis65: you need to read this, lest you find that further issues you post go unanswered. I will add this to your Excel post as well.
http://www.excelguru.ca/content.php?184

[vis65]

Ok, just figured out that my post was actually in an Excel forum, which means this is cross posted here
http://www.mrexcel.com/forum/microso...ml#post4670114

vis65: you need to read this, lest you find that further issues you post go unanswered. I will add this to your Excel post as well.
http://www.excelguru.ca/content.php?184

I am really sorry Micron. I really read the forum rules but I have never heard about the forum cross posters. I just read << http://www.excelguru.ca/content.php?184>>. I apologize. Thanks for your warning.

[Micron]

Don't take it too hard, I only meant that many responders won't answer a post that has been cross posted (provided they notice it first).
It is usually an honest mistake that doesn't get repeated once you realize the aggravation that it can cause. Thanks for reading the treatise on cross posting, and on behalf of everyone else, welcome to the forum! We're here to help whatever way we can.

[vis65]

Don't take it too hard, I only meant that many responders won't answer a post that has been cross posted (provided they notice it first).
It is usually an honest mistake that doesn't get repeated once you realize the aggravation that it can cause. Thanks for reading the treatise on cross posting, and on behalf of everyone else, welcome to the forum! We're here to help whatever way we can.

Ok, thank you Micron.