+3I have a table with 8000 records that lists out where in our warehouse we keep our items. I’d like to group the locations of the same item by listing the locations in one cell and deleting the duplicate records. How could I go about doing this? Example
Item Location
Item 0001 Shelf 1A
Item 0001 Shelf 1C
Item 0002 Shelf 1B
Item 0002 Shelf 3A
Item 0002 Shelf 5C
Item 0003 Shelf 1A
Desired output
Item Location
Item 0001 Shelf 1A, Shelf 1C
Item 0002 Shelf 1B, Shelf 3A, Shelf 5C
Item 0003 Shelf 1A
Best answer by Alexey_Gusev
Hi,
Duplicate ‘Item’ field
Turn ‘Item copy’ field into Linked to …. New table
Switch to a new table, click on linked field, add Lookup fields - ‘Location’
(note: if you have duplicate Locations for some Item, and want to have unique set, use Rollup instead of Lookup. Think of it as ‘Rollup is Advanced Lookup” )
+25Hi,
Duplicate ‘Item’ field
Turn ‘Item copy’ field into Linked to …. New table
Switch to a new table, click on linked field, add Lookup fields - ‘Location’
(note: if you have duplicate Locations for some Item, and want to have unique set, use Rollup instead of Lookup. Think of it as ‘Rollup is Advanced Lookup” )
+3Thank you!! and thank you for anticipating my next question and solving it by suggesting Rollup as well!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.