Split to row, multiple columns as once, same delimiter

[wonka1234]

Hi,

How can I do this

col 1	col 2	col 3
Toronto;NewYork	Raptors;Knicks	Submitted;Submitted

col 1	col 2	col 3
Toronto	Raptors	Submitted
NewYork	;Knicks	Submitted

This is sample data and could be more values in the columns.

[Qiu]

@wonka1234 
THe Transpose and CrossTab Combination is always good choise for dealing multiple column issues. 😁

[binu_acs]

@wonka1234