How could I separate one column into multiple colums with their values?

Hello.

I was looking for some examples but I’m confused about those.

Please, need some help with how to separate

the first column into multiple columns.

Desired Output:

The sheet “export” contains the disordered data.
The example of the desired output is in “hoja1”.
I’d like to paste the separated data in “hoja2”.

I had to change it to .xlsx because I can’t upload .csv .
Could someone share an example of file.xaml, please.

Thanks.
desired.xlsx (13.9 KB)

@pprin001
Hi

Use Read CSV activity and pass the column separator (,)

The output is a DataTable that you can save

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.