How to move the data into another column

[enkenmendoza]

Hi I have a problem regarding my data in another column.

I have these data that the other data is not on its right column. I want to move it to its right column. Example

Code:  Name:

11111   (Empty)

22222  (Empty)

  Apple  (Empty)

I want to move the apple into another column:

Code:     Name:

11111      Apple

2222      Apple

Can you help me with this one?

[Qiu · Accepted solution]

@enkenmendoza 

Hope this will work for you.

[enkenmendoza]

Hi thank you for this. I would like to ask if what is "d" in the regex match tool stands for? 

[enkenmendoza]

How about if the data in the column have the same word format.

Description:   Asg:

Payable       (Empty)

Receivable   (Empty)

Recorded to  (Empty)

Expected output

Description:   Asg:

Payable        Recorded to

Receivable   Recorded to

How can I move the other word to another column?

[Qiu]

@enkenmendoza 

\d means digit, 0, 1, ...

Therefore, related to your second question, what will be criteria to move or not move the data?

So 

Payable       (Empty) - Why not move?

Receivable   (Empty) - Why move?

Recorded to  (Empty) - Why move?