Hello,
If you could please look at the attachment I have, it will give a better understanding of my project. So I am working to speed up my reporting for our inventory reports. In the back we have many items, but some items are in different places (one item could be in 5 places and another one could be in one or two). So for my reporting, I must show where each item is by a certain fixture location. Right now I use a Pivot table (Sheet2) to show the multiple locations of each item that I search for. But some items are so close in name, for example A-2 and A. So my end goal is to have a formula that will grab the locations and place a comma and space in between (i.e: Fixture 1, Fixture 2, Fixture 3) and stop once it gets to the next item. You can see what is happening to me right now and what I would like to get in Sheet 2 on the right side of the pivot table.
Thanks for the help! Have a great rest of your day!
Bookmarks