I have a long list of data, about 200 rows, and each row contains multiple columns of data and a region column. In this region column, it contains a list of regions for example, New York, Italy, Mexico. I want to be able to split the list into X rows where X is the number of items in the list but each row contains the elements from the row.
From the example, 3 rows would form: a row containing New York, a row containing Italy and a row containing Mexico.
The stackoverflow link this is based on is something that's really close to what I'm looking for but it contains extra bits like counting and it doesn't seem to really work when the content contains spaces.
I want to have this new data be put into a new sheet and not the existing one if possible.