Move duplicate values to new field?

Hi all, pretty new to Access.

I am trying to setup a query to show all the data on a single row by editing just 1 table. I know a workaround would be creating multiple tables (eg. Test comps 1, test comps 2, etc….) but I would like to remove those dupe part numbers and format into one. If you can point me to the right direction, it would be much appreciated. Anything will help. Thank you!

Here’s what I have

https://imgur.com/6eZKsLc : Main table with a subdatasheet that I can add records into

https://imgur.com/qFYksUm : The subdatasheet referenced

https://imgur.com/dbd7YV3 : What I’m trying to do.

submitted by /u/ChanounOzakaki
[link] [comments]