Help with Delimiting

[DRJ1994]

Hi guys,

Hopefully someone can help with my query, although I am not sure if what I am trying to do is possible or not.

I have a table with the column pictured below. 

I am trying to delimit by ";" (The / is fine and I do not need to delimit by this). So if we take the top row for example it should be split into rows as follows:

Attendance allowance / state pension / pension credit
Benefits advice

Physical health

Visit

Well being

The issue I am having is PBI is counting these now as 5 seperate entries rather than 1. For example the source data there are only 4600 entries, but when I delimit in PBI and performing a count there are over 12000 entries. So I think the issue is that it is counting each row as it's own entry, I understand why this is happening but I am just trying to see if there is a way to bring it closer to the 4600 that is on the source data.

Is there a way to fix this? I have tried a few different things but have had no joy. 

Thanks in advance.

DRJ.

[HotChilli]

What are you trying to fix? 

--

Are you trying to find a way to keep the related rows 'together'?  If so, are there any other columns in the table which act as a key?