separate columns and concatenate to old columns in table

[Saraabdi955]

Hi all,

I need your help.

I have a table like T1:

 I want to separate column named "B1:B2" using regex to two different columns and concatenate new column "B1" to column "C1" and new column "B2" to column "C2" like this:

Thanks for helping me,

[AngelosPachis · Accepted solution]

Hi @Saraabdi955 

So depending on your actual input, I have prepared two workflows that can help out.

Assuming that your input is this

then you can use a text to columns tools instead of a regex to split to new columns every time you meet the delimiter ":"

Then if your input actually have nulls stored as text, as shown below

then you should first replace those with empty cells (I did that with a multi-field formula) and then apply the same steps as in the previous workflow

Hope that helps.

Regards,

Angelos

[Saraabdi955]

Hi @AngelosPachis 

That's right.

Thanks a lot Angelos.

Best Regards,