Data manipulation - Changing Number Row

[EvansM]

Hello Everybody,

I need some help to manipulate data in a column. Please refer attached two excel worksheets. One is ITEMNO-INPUT (Data sample)  and the second one is ITEMNO-OUTPUT (Expected Results)

I did try to use Multi- Row Formula, but the logic is too complicated to work the way I wanted.

I want the [CANOTEITEM] column to reflect ITEMNO - OUTPUT excel (Expected Results). This column needs to be INT Value.

Thanks In advance 

[afv2688 · Accepted solution]

Hello @EvansM ,

Here you can find them re-ordered to your original output:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards