Is it possible to look up a cell in one tab against another, find multiple instances of the number, then using a different column pick out unique value and combine the unique values into a cell on the original tab?
Hopefully the below helps clarify.
Table 1 contains the reference number i want to look up:
Reference Value
1
2
3
4
Table 2 contains the values i need for my final table against the reference number i am looking up. A reference can have multiple values
Reference Value
1 Car
2 Car
3 Car
4 Car
1 Car
1 Bus
1 Train
4 Bus
Table 3 shows the end result. For each reference number the values are merged into one cell allowing one line for each reference.
Reference Result
1 Car;Bus; Train
2 Car
3 Car
4 Car;Bus
Hopefully someone has done something similar to this before. If i need to provide any further clarity, please let me know.
Kris
Bookmarks