RJD1993
10-11-2015, 09:51 AM
I have information in column A and need certain information to be moved into columns B & C.
Game Review User
1
97
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.
Game Review User
1
97
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.