Onebracketshort
New Member
- Joined
- Dec 19, 2019
- Messages
- 37
- Office Version
- 2010
- Platform
- Windows
Have a series of data in one column I'm trying to make easier to work with.
Looking to move the date entry in A3 to B4
Looking to move the vehicle entry value in A2 to C4
Similarly looking to move date entry in A8 to B9
looking to move vehicle entry A7 to C9
These moves are to be repeated for several thousand rows in total.
The vehicle value in column A is category general.
The date entry in column A is category custom dd-mmm-yy
The time entry in column A is category custom hh:mm
XL2BB capture:
Thanks for taking a look and for any pointers or solutions
Looking to move the date entry in A3 to B4
Looking to move the vehicle entry value in A2 to C4
Similarly looking to move date entry in A8 to B9
looking to move vehicle entry A7 to C9
These moves are to be repeated for several thousand rows in total.
The vehicle value in column A is category general.
The date entry in column A is category custom dd-mmm-yy
The time entry in column A is category custom hh:mm
XL2BB capture:
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Date | Vehicle | |||
2 | Lorry | ||||
3 | 03-Aug-20 | ||||
4 | 21:47 | ||||
5 | 22:03 | ||||
6 | 11:16 | ||||
7 | Coach | ||||
8 | 04-Aug-20 | ||||
9 | 21:35 | ||||
10 | 22:37 | ||||
11 | 23:43 | ||||
12 | Tractor | ||||
13 | 05-Aug-20 | ||||
14 | 19:15 | ||||
15 | 19:57 | ||||
Sheet2 (2) |
Thanks for taking a look and for any pointers or solutions