Pulling data from one column to another

[Ahasan13]

Hi all,

I have I have something like this below on excel. How do I pull the number "10100-000-00" from column "B" and move it over to "A" and then have it repeat until it hits a new number, which then repeats by itself?  

[binuacs]

@Ahasan13 Are you looking for something like this?

[ShankerV]

Hi @Ahasan13 

As it is an open ask, have tried all 3 possible outcomes as solution.

Please use the solution which suits your expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @Ahasan13 

Solution 2:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @Ahasan13 

Solution 3:

Where we can remove the row with same 10100-000-00 in both columns.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Ahasan13]

this works but there is another issue, I have something thats call "Account" and then I also have something that's call "Legal Number:"

so this is what I wrote in on the formula below but it did not do anything for the "Legal Number" part. Please help

IIF([F1] = 'Account' and 'Legal Number:' , [F2],[Row-1:F1])

[ShankerV · Accepted solution]

Hi @Ahasan13 

You need to use OR

IIF([F1] = 'Account'  OR [F1]= 'Legal Number:' , [F2],[Row-1:F1])

[ShankerV]

Hi @Ahasan13 

Please find the expected output for both Account and Legal Number

IIF([F1] = 'Account' OR [F1]= 'Legal Number' , [F2],[Row-1:F1])

|Input was:

Many thanks

Shanker V