[Solved] Need function to change X1 X1 X1 to X1 X2 X3

[AlexandraNyx]

hello kind people

I changed column A to look like column C.
I did it manually

Problem is there are thousands of these.

Is there a function put into a helper column that can do the trick?
most appreciative of any insight!

sheet posted

[FJCC]

I am sorry, I do not understand what you want to do. You say you changed column A to look like column C but the two are not always equal. For example, they differ in row 5. Does it not work to put in A2 the formula

Code: Select all

=C2

and then copy that down the whole column?

[F3K Total]

Hello
D2:

Code: Select all

=IF(ISBLANK(A1);1;D1+1)

E2:

Code: Select all

=IF(ISBLANK(A2);"";LEFT(A2;3)&D2)

Pull down
Works only if your codes have lenght 4 and only till 9 per block.
R

[AlexandraNyx]

To FJ

Thanks for the answer. 2pW represent a result. The 1 represents the number of times for this particular result. If the same result happens more than once I have to change the 1 to 2 or the number of times in a row it happened - thus, that's what C represents. Me changing A.

[AlexandraNyx]

To FK3

Love you brother. Works fantastic. I do have some that are over 9 but this is great. Super happy.

bless you my friend
alexandra