Hi,
I have data a little like this:
| Field | Value |
| IP | 812 |
| Site | North |
| Service | Acme |
| IP | 813 |
| Site | South |
| Service | Acme |
| IP | 814 |
| Site | North |
| Service | Bang |
I know that the data that belongs together is on 3 rows, e.g. 1,2 and 3 is one record, 4,5,6 is another and so on.
What I need is:
| IP | Site | Service | Unique ID (created) |
| 812 | North | Acme | 1 |
| 813 | South | Acme | 2 |
| 814 | North | Bang | 3 |
Any advice appreciated, as I have no control over the data format I'm receiving.
Cheers,
Dean
