Help! Combining reports with multiple values assigned to same look-up

[farnlc]

I am trying to combine a few different reports for my team in the field using Access. I'm a self learner so the only way I can figure to make it work is if I have one master Excel table with all the info I need for each location on one row. The problem is that I get a report for items carried in a location that has a separate row for each item that I need to pick up. I'm fairly familiar with vLookup, but I think that only applies if there is only one value assigned to the lookup. In this case there are Widgets, Dodads, and Thingy's.

It looks like this:

1 Widget
1 Dodad
1 Thingy
2 Widget
2 Dodad
3 Widget
3 Dodad
3 Thingy

I need it to look like this:

1 Widget Dodad Thingy
2 Widget Dodad
3 Widget Dodad Thingy


Any help would be greatly appreciated! This would really help me make a good impression with my supervisors!

I attached a slightly more sophisticated example of what I'm working with in Excel.

[jindon]

Try the attached.

[farnlc]

Wow that worked amazing! Now how do I reproduce that with my real data?

Thanks in advance for your help!