I joined two tables together.
First table is the item master table (the products we purchase)
Second table is the item location ( The location in which these items are set up to purchase)
Here is an example of the data
ITEM LOCATION
4280 03NSK
4280 01NSK
4280 03855Book1.xls
42800 57649
42800 02NSK
42800 57NSK
42800 03NSK
42800 67NSK
42800 65NSK
42800 01NSK
42800 91NSK
428000 67005
428001 15001
428001 15004
428001 15005
428002 57NSK
428002 57NBL
428003 57NBL
428003 57NSK
What I'd like to do is pull this data but instead of the data coming back in rows, I'd like it to appear as:
Item Location
4280 03855,01NSK,03NSK
ect..
First table is the item master table (the products we purchase)
Second table is the item location ( The location in which these items are set up to purchase)
Here is an example of the data
ITEM LOCATION
4280 03NSK
4280 01NSK
4280 03855Book1.xls
42800 57649
42800 02NSK
42800 57NSK
42800 03NSK
42800 67NSK
42800 65NSK
42800 01NSK
42800 91NSK
428000 67005
428001 15001
428001 15004
428001 15005
428002 57NSK
428002 57NBL
428003 57NBL
428003 57NSK
What I'd like to do is pull this data but instead of the data coming back in rows, I'd like it to appear as:
Item Location
4280 03855,01NSK,03NSK
ect..