I could do with some suggestions for getting data from 2 rows into one. To explain further I have a phone report table that I need to manipulate so I can run queries for graphs and stats. I've posted an image that will help explain.
Basically the data I have shows the person's name on one row, then their data is on the next row.
So for example;
Row 1: Joe Bloggs
Row 2: All field data relating to Joe Bloggs
Row 3: Mike Jones
Row 4: All field data relation to Mike Jones
Is there a relatively simple way to approach this? Thanks very much for any suggestions.
Basically the data I have shows the person's name on one row, then their data is on the next row.
So for example;
Row 1: Joe Bloggs
Row 2: All field data relating to Joe Bloggs
Row 3: Mike Jones
Row 4: All field data relation to Mike Jones
Is there a relatively simple way to approach this? Thanks very much for any suggestions.