tonkerthomas
Board Regular
- Joined
- Feb 12, 2014
- Messages
- 56
Good morning everybody
I have a large table which I need to reorganise. It has two key fields and one of data, thus:
<tbody>
</tbody>
I need to aggregate that data by contract and type BUT keep the clauses separate (i.e. not sum or count them) AND keep them in order:
<tbody>
</tbody>
Any given Contract will have between 2 and 10 Lines, and any given Line can have between 1 and 20 Charge IDs.
A pivot table doesn't appear to be capable of this (you have to aggregate somehow) and I've had a play around in "Get Data" but I don't really know what I'm doing. I'm sure there's a straightforward answer to this, one way or another, but I can't find it. Can somebody help me?
Thanks, as ever, in advance for your help.
Cheers
Jeff<body id="cke_pastebin" style="position: absolute; top: 364.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
I have a large table which I need to reorganise. It has two key fields and one of data, thus:
| Contract | Line | Charge ID |
| 10914 | 1 | 10010016 |
| 10914 | 1 | 10010932 |
| 10914 | 2 | 10020624 |
| 10915 | 1 | 10000883 |
| 10915 | 2 | 10010703 |
| 10915 | 2 | 10010244 |
| 10915 | 2 | 10010243 |
<tbody>
</tbody>
I need to aggregate that data by contract and type BUT keep the clauses separate (i.e. not sum or count them) AND keep them in order:
| Contract | Line | Charge ID | Charge ID | Charge ID |
| 10914 | 1 | 10010016 | 10010932 | |
| 10914 | 2 | 10020624 | ||
| 10915 | 1 | 10000883 | ||
| 10915 | 2 | 10010703 | 10010244 | 10010243 |
<tbody>
</tbody>
Any given Contract will have between 2 and 10 Lines, and any given Line can have between 1 and 20 Charge IDs.
A pivot table doesn't appear to be capable of this (you have to aggregate somehow) and I've had a play around in "Get Data" but I don't really know what I'm doing. I'm sure there's a straightforward answer to this, one way or another, but I can't find it. Can somebody help me?
Thanks, as ever, in advance for your help.
Cheers
Jeff<body id="cke_pastebin" style="position: absolute; top: 364.8px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
| 10010244 |
<tbody>
</tbody>
