how can I split values into multiple rows?

[nmitch]

Hi - I'm looking for a solution that allows me to split a value into multiple rows. I have data that can return consist of multiple values per ID separated by a space. Is it possible to transform the data to look like my example below?

[Luke_C · Accepted solution]

Hi @nmitch 

Yes, this is possible using the text to columns tool. There is a configuration to split the data to rows:

[nmitch]

that did the trick - thank you!!