This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a file that is about 150 columns and thousands of rows but 1 of the columns in the file "Differences", has multiple field names separated by semicolon which tells us the incorrect fields out of the 150 columns, this is different for each row as it is dependant of a reference ID and fields that are incorrect per ID. The below table is an example of how the fields looks for 1 particular reference. If I do a text to column on the semicolon this shows that we are breaking on 9 fields. That is the easy part.
The next part I am stuck, as each reference has a different number of fields they are breaking on (can range from 1-150 fields). I need a simple sum total of each field name that is breaking on for each reference. I have attached an example table with dummy data with 9 references as an example and the column that contains the differences field.