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?
Solved! Go to Solution.
Hi thank you for this. I would like to ask if what is "d" in the regex match tool stands for?
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?
\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?