How can I convert talbe in qv script?

[#1]

Hi, I want to conert table 1 to 2 in qv script? can this be done in qv?

table1

A	RED|BLUE|GREEN

table2

A	RED
A	BLUE
A	GREEN

[#2 · Accepted solution]

I get the function . Thanks!

MyTab:
Load MeetingID, Start, Stop,
subfield(Participants, ';') as People
from Tab1.csv;