Split to row, multiple columns as once, same delimiter

Question

Hi,

How can I do this

col 1col 2col 3Toronto;NewYorkRaptors;KnicksSubmitted;Submitted

col 1col 2col 3TorontoRaptorsSubmittedNewYork;KnicksSubmitted

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

binu_acs · Answer

@wonka1234

Qiu · Answer

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

0614-wonka1234.yxmd