Hi,
In the attachment I have 2 tables - each with different columns
There is a column of an item in the 2 tables
I need a new table that will have all the items from the 2 tables in one column
How do you do that?
Thank you very much for your help! Leah
It's not really clear to me what output you want, but your description of getting it all in one column sounds like you just want an append query to me.
I need to output a column that has all the number numbers
= 1063 data from stock sheet Y
+ 482 data from X inventory sheet
Thanks for the help, Leah
Then it appears all you need to do is remove the other columns from your 2 queries and append one to the other. Where are you stuck?
Remove unnecessary columns - I know.
The question of how to attach the 2 columns of the code - from the 2 tables
To one column?
Hello Lea,
Have a look in this blog article, it shows what needs to be done to consolidate many tables into one.
Br,
Anders
I would upload the tables into PQ, rename required columns to match, remove unnecessary columns, then append the tables.
