I have information in column A and need certain information to be moved into columns B & C.
Game Review User
197 Grand Theft Auto V User: 8.2 18-Nov-14 2 95 The Last of Us Remastered User: 8.9 29-Jul-14 3 93 Metal Gear Solid V: The Phantom Pain User: 8.2 1-Sep-15 4 92 Journey User: 8.2 21-Jul-15 5 92 Bloodborne User: 8.6 24-Mar-15 6 92
I don't really know where to begin with this which is why I don't have any code for you guys to check out which doesn't give you much to work with, but basically what I'm trying to do is delete the first number, move the second number into the "review" column (B), leave the game name, move the user score into the "user" column (C), and delete the date. Then, if possible, remove the blank rows in between the games. I can use the record function for the last part, but I tried for the rest of it and tried to replicate it for everything, but it's messy and there's too much going on.
