Dreamteam
New Member
- Joined
- Feb 22, 2018
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
Hi all
Below is a list of data in col A of football results. The data pattern is consistent - Date of match; Home team; Score (home team first) and finally Away team. And then it moves onto the next result. I have been trying to simply move it over into a more readable format - starting with cell C2. I thought this would be easy but I am cannot seem to do this. I thought initially that I would put col A into an array and then move it to the table - but to no avail.
Any help would be much apprecitated.
Many thanks
Dt
Below is a list of data in col A of football results. The data pattern is consistent - Date of match; Home team; Score (home team first) and finally Away team. And then it moves onto the next result. I have been trying to simply move it over into a more readable format - starting with cell C2. I thought this would be easy but I am cannot seem to do this. I thought initially that I would put col A into an array and then move it to the table - but to no avail.
Any help would be much apprecitated.
Many thanks
Dt
Football - probabilities.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | 19.05. 16:00 | Date | Home Club | Home Goals | Away Goals | Away Club | |||
3 | Chelsea | 19.05. 16:00 | Chelsea | 2 | 1 | Everton | |||
4 | 2 - 1 | 19.05. 16:00 | Liverpool | 1 | 0 | QPR | |||
5 | Everton | 19.05. 16:00 | Manchester City | 2 | 3 | Norwich | |||
6 | 19.05. 16:00 | 19.05. 16:00 | Newcastle | 0 | 1 | Arsenal | |||
7 | Liverpool | 19.05. 16:00 | Southampton | 1 | 1 | Stoke | |||
8 | 1 - 0 | ||||||||
9 | QPR | ||||||||
10 | 19.05. 16:00 | ||||||||
11 | Manchester City | ||||||||
12 | 2 - 3 | ||||||||
13 | Norwich | ||||||||
14 | 19.05. 16:00 | ||||||||
15 | Newcastle | ||||||||
16 | 0 - 1 | ||||||||
17 | Arsenal | ||||||||
18 | 19.05. 16:00 | ||||||||
19 | Southampton | ||||||||
20 | 1 - 1 | ||||||||
21 | Stoke | ||||||||
Sheet5 |