This is based on the version of Excel I currently use (2003) - assuming your data is in columns A and B.
In a new column, add the following:
=A1&" - "&B1
That should then have a new column with the layout you require. As it's a formula, you may then want to change it to just the values. You can do this by selecting the column, copying it, then using one of the paste options to just paste the values rather than the formula. Can't remember the exact wording of that option.
It was a trick question
****. Bollocks. Shit.
Schooled by Spion.
P | Pld | Pts | |
1 | Leicester | 46 | 97 |
2 | Ipswich | 46 | 96 |
3 | Leeds Utd | 46 | 90 |
4 | Southampton | 46 | 87 |
5 | West Brom | 46 | 75 |
6 | Norwich City | 46 | 73 |
7 | Hull City | 46 | 70 |
8 | Middlesbro | 46 | 69 |
9 | Coventry City | 46 | 64 |
10 | Preston | 46 | 63 |
11 | Bristol City | 46 | 62 |
12 | Cardiff City | 46 | 62 |
13 | Millwall | 46 | 59 |
14 | Swansea City | 46 | 57 |
15 | Watford | 46 | 56 |
16 | Sunderland | 46 | 56 |
17 | Stoke City | 46 | 56 |
18 | QPR | 46 | 56 |
19 | Blackburn | 46 | 53 |
20 | Sheffield W | 46 | 53 |
21 | Plymouth | 46 | 51 |
22 | Birmingham | 46 | 50 |
23 | Huddersfield | 46 | 45 |
24 | Rotherham Utd | 46 | 27 |