Forum Discussion
Solved
CROSS JOIN two column ... row by row
subject title is mis-leading but here is what I would like to achieve I have table like this; would like to convert to; any idea? thanks
Hi derumiya
Split the column by Delimiter, a comma,
and split into rows for each occurrence of a comma
Result
regards
Phil
PhilipTreacy
Super User
Super UserHi derumiya
Split the column by Delimiter, a comma,
and split into rows for each occurrence of a comma
Result
regards
Phil
great! thank you so much
