Power Query list replace / insert

Hi,
I have been trying to do a cumulative total , but it contains text ie { 1,2,3 , "A", 2,2,"X",4}

I have tried replacing with a zero and then putting it back by using the position of the text values.

so

Please Login or Register  to view this content.

but I need the first occurrence of "X" replaced by new{c} and the second by new {c + 1} , but of course "X" not longer occurs so i just get the first.
I don't know if there is something similar to the splitter split by each ?

I have included a solution, but it's not mine and I'm still working through how it all works so if anyone has other ideas I would be interested.

Richard.

There are many ways you could go about it - for example:

Please Login or Register  to view this content.

or something like:

Please Login or Register  to view this content.

That list only has numbers in it...

was making a general point about not having to us skip,
but with text ;

Please Login or Register  to view this content.

Richard

My point was just that the functions you were using in the previous one wouldn't get the right results with text in there, at least not without writing a custom comparer function.