tommsegers
New Member
- Joined
- Dec 8, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- MacOS
Hi everyone
I have a Sheet containing a column which contains comma separated values containing locations and a value
On a new sheet I have a list of all available locations and need to generate a table that looks like showing the value after the : of that specific location.
And preferable also adds the columns if the ID exists so i don't have to manually create every column header
Another issue is that the Location names need to be an exact match as some names contain similar words like "Brussels North", "Brussels", "Antwerp North"
I have tried Search formulas without success so far
Thank you
Tom
I have a Sheet containing a column which contains comma separated values containing locations and a value
Item ID | Location results |
112 | Location A :1;Location B:3;Location C:4;Location D:1 |
113 | Location A :5;Location F:1;Location X:9;Location Z:1 |
116 | Location AA:3 |
On a new sheet I have a list of all available locations and need to generate a table that looks like showing the value after the : of that specific location.
And preferable also adds the columns if the ID exists so i don't have to manually create every column header
Location | 112 | 113 | 116 |
Location A | 1 | 5 | 0 |
Location B | 3 | 0 | 0 |
Location AA | 0 | 0 | 3 |
Another issue is that the Location names need to be an exact match as some names contain similar words like "Brussels North", "Brussels", "Antwerp North"
I have tried Search formulas without success so far
Thank you
Tom