Forum Discussion

DhritimanL's avatar
DhritimanL
Copper Contributor
Nov 12, 2020

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...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 12, 2020

DhritimanL Since you explicitly asked for a PQ solution, I'm giving you just that. I suspect that your real data is much more complicated and you don't want a lot of manual interference with helper columns and complex formulae. Or do you just want to learn about PQ?

Just add to the blue table and refresh the green one, as long as you make sure that the Name is always  in the row directly above the row that includes the string "urchase". PQ is case sensitive. This way, you will capture all occurrences of "purchases", "Purchases", "purchase" and "Purchase"

  • DhritimanL's avatar
    DhritimanL
    Copper Contributor
    Nov 12, 2020

    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

     

Resources