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?
Solved! Go to Solution.
Hi @nmitch
Yes, this is possible using the text to columns tool. There is a configuration to split the data to rows:
that did the trick - thank you!!