I'm pretty new to PLP, so this may be simple, but I have some data that essentially looks like this:
sub_id | rate | value
----------------------
12345 | 22 | 0
----------------------
12345 | 66 | 20
----------------------
12345 | 200 | 50
----------------------
But I want to merge cells together with the same 'sub_id' values. So the above would look like this in a report:
sub_id | rate | value
----------------------
| 22 | 0
--------------
12345 | 66 | 20
--------------
| 200 | 50
----------------------
Anyone have any ideas?
thanks,
simon.
sub_id | rate | value
----------------------
12345 | 22 | 0
----------------------
12345 | 66 | 20
----------------------
12345 | 200 | 50
----------------------
But I want to merge cells together with the same 'sub_id' values. So the above would look like this in a report:
sub_id | rate | value
----------------------
| 22 | 0
--------------
12345 | 66 | 20
--------------
| 200 | 50
----------------------
Anyone have any ideas?
thanks,
simon.