Need advice

[Devsadhan86]

Hi All,

I am trying to transform one the data set (dummy shared) which has data in excel format and one of the column has cells with multiple values present in that. 

now the ask if to get the multiple values from each cell and make a standard transformed data set  

Any support would be highly appreciated.

BR

Dev

[fmvizcaino · Accepted solution]

Hi @Devsadhan86 ,

You can achieve that output by using a text to columns tool. But using the functionality to split column to rows.

Best,

Fernando Vizcaino