Multivalue column split into table?

[cheezy]

i have a datasource that is converted  into a table. There are columns within the table that contain multivalues separated by a semi colon, So for example like this:

ID	Department	Years	Colour
1	Billing;Stores;Office	3	Red;Blue
2	Office;Billing	7	Green;Orange
3	Stores	10	pink

So i am trying to extract the multivalue fields, perhaps put them into their own table? But i cannot see anyway of doing this after i have already converted the original datasource into a table. Any ideas?

[Samarth_18 · Accepted solution]

Hi @cheezy ,

If I took your question correctly then you could follow below steps:-

1. Select Department column then use split column by delimiter

2. Now select the options as below:-

3. Follow the same for colour column.

4. Final output:-

Refer the file below.

Thanks,

Samarth

[cheezy]

thanks  for your help - this works