Hey everyone,
I have this excel table in Column A and B, but I want to bring into the form of D and E:
I tried to use a Textjoin, but it doesn't seem to be working. Any help would be much appreciated!
Thank you and best regards,
Klemens
I have this excel table in Column A and B, but I want to bring into the form of D and E:
Keywords_Search_Klemens.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Key | ActualCategories | Key | ActualCategories | |||
2 | 1 | IT-Strategie | 1 | IT-Strategie | |||
3 | 2 | IT-Strategie | 2 | IT-Strategie | |||
4 | 3 | IT-Strategie | 3 | IT-Strategie | |||
5 | 4 | Vorgaben&Maßnahmen | 4 | Vorgaben&Maßnahmen | |||
6 | 5 | IT-Strategie | 5 | IT-Strategie, Informationssicherheit | |||
7 | 5 | Informationssicherheit | 6 | IT-Strategie, Informationssicherheit, Vorgaben&Maßnahmen | |||
8 | 6 | IT-Strategie | |||||
9 | 6 | Informationssicherheit | |||||
10 | 6 | Vorgaben&Maßnahmen | |||||
MappedSource |
I tried to use a Textjoin, but it doesn't seem to be working. Any help would be much appreciated!
Thank you and best regards,
Klemens