Split data

ivoiculescu2020

Hello, team

I need your help to figure out an easier way to split the data from 1 row to several rows. I have an Excel file that shows the drug that was shipped to clinical sites. However, some rows have multiple site numbers in the same row. I attached an example. I need to split the site numbers in different rows. For the attached example, I have 2 rows of data for 4 sites that received 2 drug lots. Instead of 2 rows, I need to see 8 rows, each row showing a different site @#.

What I did was use the Select Records and Text to Columns functions but I was wondering if there is an easier way. The file I have is fairly small, just a few hundreds of rows so the Select Records and Text to Columns was the easiest way for me because I could check the data easier (visually), however if I have a huge file I am not sure this is the best way to go.

Does anyone have a better idea?

Thanks,

Ioana

Question.png

JosephSerpis

Hi @ivoiculescu2020 that is a good approach using the text to column tool another approach would be to use the Regex tool and Tokenize however this would work in a similar way especially since your sites are separated by a comma.