Forum Discussion
Splitting Data in multiple rows of single column into different columns
Hi! Please can you look at the sample raw data and expected output here below which should help understand how the data is set up and the desired output. I would like to be able to split the rows a...
Riny_van_Eekelen Thank you So much, yes indeed the actual data has other key words so i went ahead and edited the m-code and replaced "purchases" with the required words and a few other minor tweak to make it work like a charm for my data.
Much appreciated and grateful.
Thank you once again.
Kind regards
Dhritiman
DhritimanL Glad you could fix it.