About cell splitter & output column reverse

[Zyw]

Hello everybody,
Need quick support…

This is the original table, and there is some rows needs to be split (by 2 spaces).
Sequence of rows can not be changed.
E.g. "Top RF(Pulse) Point1 Proofread Value:

By using “Cell Splitter”, the result becomes:

While I need to reverse the 2 columns when doing the split, which means the “Proofread Value” should go to the 1st column, and “Top RF(Pulse) Point1” should go to the 2nd column.

How can I make it?
Thank you so much.

Regards,
Zy

[aworker]

Hi @Zyw

Could you please upload here in excel format the data you are displaying in the first snapshot. It will help us to bring you a quick answer too

Best,

Ael

[Zyw]

Hello @aworker
Thanks for help. Here comes the sample data.
111.xlsx (3.6 KB)

Regards,
Zy

[aworker]

Hi @Zyw

My pleasure. Is this what you need ? It may need some changes to fully suit your required final result.

20210607 Pikairos About cell splitter & output column reverse.knwf (29.6 KB)

Hope this helps

Best regards,

Ael

[Daniel_Weikert]

Have you tried using Column Resorter afterwards? Maybe I miss something here.

[elsamuel]

I agree with @Daniel_Weikert. Unless there’s some other requirement that you’re not mentioning, the Column Resorter node is the way to go.

[aworker]

As far as I understood, It is not the columns but the values that need to be position inversed when the “Proofread Value” string was present in the cell. But obviously I may be wrong …

What did you mean @Zyw ?

Thanks,

Ael