Can you helpme pease, to move or convert a row into multiple columns?
Row ID User name Profile User name Profile
ROW0 Alejandro Operativo Daniel Compras
I want to show:
Row ID User name Profile
Row0 Alejandro Operativo
Row1 Daniel Compras
Hi @Sand_Kob , it looks to me that you want the other way around, that is move multiple columns into multiple rows…
Can you show us what the real column names look like? I mean, you can’t have 2 columns with the same name. You can’t have 2 columns called “User name” and you can’t have 2 columns called “Profile”.
You can look into the Transpose node or the Pivoting node for moving columns to rows and rows to columns.
Use the cell splitter node and choose as new columns for the output. Separator seems to be a space
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.