Creating list from data with blank spaces and also eliminating a repeating value

[simmo86]

I have a list of data that has in one column, fund provider, then below, the fund, then "fund provider" and then below another fund, how do I eliminate the "fund provider" text in the column so I get a list of all the actual funds. Sample data has been uploaded

Thanks in advance

Alex