Rows to columns

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:

ContractLineCharge ID
10914110010016
10914110010932
10914210020624
10915110000883
10915210010703
10915210010244
10915210010243

<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:

ContractLineCharge IDCharge IDCharge ID
1091411001001610010932
10914210020624
10915110000883
109152100107031001024410010243

<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>
</body>
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,099,011
Messages
5,466,014
Members
406,461
Latest member
Garrus

This Week's Hot Topics

Top