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.
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
Thanks for help. Here comes the sample data.
111.xlsx (3.6 KB)
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
Have you tried using Column Resorter afterwards? Maybe I miss something here.
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.
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 ?
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.