Hi,
I have a column in my data which looks like below:
Column A |
I have to go |
I need coffee |
I am not feeling well |
I should have not said that |
He is good |
His phone is ringing so loud for the past hour |
I need to split it into 2 columns as follows:
Column A | Column B | Column C |
I have to go | I have to | go |
I need coffee | I need | coffee |
I am not feeling well | I am not feeling | well |
I should have not said that | I should have not said | that |
He is good | He is | good |
His phone is ringing so loud for the past hour | His phone is ringing so loud for the past | hour |
Essentially, the last word from each record needs to be split into a new column. Can anyone please suggest? Thanks.
Solved! Go to Solution.
Just realized it's much easier than I thought. I changed the format from datetime to date while importing. Problem solved!