Forum Discussion
derumiya
3 years agoNew Member
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
2 Replies
- PhilipTreacy
Super User
Hi derumiya
Split the column by Delimiter, a comma,
and split into rows for each occurrence of a comma
Result
regards
Phil
- derumiyaNew Member
great! thank you so much