Accounts & Finance

 

Movie Title & Star Casts…….cell A1
The Hunger Games………….cell A2
Jennifer Lawrence, Josh HutchersoncellA3
Red Sparrow …………………cell A4
Jennifer Lawrence, Joel Edgerton….cell A5
 
 So here’s the thing. I need to move only the two star casts from the cell whereever it is to the column adjacent to the right of the movie title.
Ex. Jennifer Lawrence, Josh Hutcherson must move to the same row as the movie title – The Hunger Games – in this case.
Ive got atleast 65,000 lines of data.
Thanks gurus for your solution, ASAP.
 

By: James Perry

Leave a Reply

Your email address will not be published. Required fields are marked *