Split a Column, Including the Header Row

[ruidijnj]

Hi,

Could someone show me how I can split the following concatenated data components to separate column? There are 2 difficulties for me:

1. The headers row is also concatenated and it needs to be split too.

2. The last part of each string (e.g. Header 3;, 000-XYZ;, and 001-XYZ;) contained unwanted semicolons at the end. How can I get rid of them?

Header 1; Header 2; Header 3;
123; ABC; 000-XYZ;
456; DEF; 001-XYZ;

Thanks

[kwilda]

Hi

you can split to columns, formula off the last semi colon and use the dynamic rename tool to promote the 1st row to column headers

See attached workflow

[flying008]

Hi, @ruidijnj 

FYI.