SOLVED
Data in Cell Split to Multi Columns Dynamically
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
k3pineapple
8 - Asteroid
‎06-18-2024
08:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team, good day
Trying to separate data in the same cell, bit hard to use "Text to Column" to do this, so coming to seek your kind help to solve it. Much appreciated.
Data format required to split : "(name1);(ID1),(name2);(ID2),(name3);(ID3),....,(namex);(IDx)" => create multi column to fit individual data in brackets
Input
Client | Country | Code Name | Primary | Secondary | Undefined |
ABC | AA | X3AVC3 | Amy A;AMYA | BOB B;BOBB,Cindy C;CINDYC | Mnm M;MM |
BCD | BB | 123DSA | Amy A;AMYA | ||
CDE | CC | DFJAASD2 | Cindy C;CINDYC,Dave D;DAVD,Eason E;EAE | ||
DEF | DD | 1234FGDA | Dave D;DAVD | ||
EFG | DD | 1DFGBTAS | Frank F;FRANKF,Geo G;GEOG | Xin X;XINX,Zzz Z;ZZZZ |
Expect Output
Client | Country | Code Name | Primary1 | Primary1 ID | Primary2 | Primary2 ID | Secondary1 | Secondary1 ID | Secondary2 | Secondary2 ID | Secondary3 | Secondary3 ID | Undefined1 | Undefined1 ID | Undefined2 | Undefined2 ID |
ABC | AA | X3AVC3 | Amy A | AMYA | BOB B | BOBB | Cindy C | CINDYC | Mnm M | MM | ||||||
BCD | BB | 123DSA | Amy A | AMYA | ||||||||||||
CDE | CC | DFJAASD2 | Cindy C | CINDYC | Dave D | DAVD | Eason E | EAE | ||||||||
DEF | DD | 1234FGDA | Dave D | DAVD | ||||||||||||
EFG | DD | 1DFGBTAS | Frank F | FRANKF | Geo G | GEOG | Xin X | XINX | Zzz Z | ZZZZ |
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Dynamic Processing
- Output
3 REPLIES 3
‎06-18-2024
08:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
T
alexnajm
17 - Castor
‎06-19-2024
05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-19-2024
06:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@alexnajm Very Cool, many thx. Logic opened my mind.