Forum Discussion

Copper Contributor

Feb 25, 2022

Count string occurrences in semi-colon delimited data set

Hi all, this is my first post, so pls be nice. I have a large survey dataset (80k IT developers). One of the rows contains an unspecified number of programming languages per cell separated by semic...

excel

Formulas and Functions

Lorenzo

Silver Contributor

Feb 25, 2022

Hi Csaba73

Easily doable with Get & Transform aka Power Query assuming you run a recent version of Excel on Windows + there is always a space between the Country name and the 1st language, as in the few examples you provided

Sample attached