tonkerthomas
Board Regular
- Joined
- Feb 12, 2014
- Messages
- 56
Good morning everybody,
It seems as though my previous attempt didn't post properly somehow (when I click on it there's nothing there at all), so let's try again:
I have a table with two key fields and one data field. I need to reorganise it so that the key fields are summarised, with the data in columns against those fields, rather than in rows. It currently looks like this:
<tbody>
</tbody>
... and it needs to look like this:
<tbody>
</tbody>
... with the Charge IDs summarised by Contract and Row BUT appearing in the order in which they were originally listed. Any given contract can have between 2 and 10 Rows, and any given Row can have up to 20 Charge IDs.
I've tried this in a pivot table but it seems as though you have to aggregate your data somehow, which is not what I want. I have also had a bodge about in Power Query but I don't really know enough about it to make it work. I'm sure there's a simple solution to this but I can't get there by myself. Any help would be hugely appreciated.
Cheers
Jeff
It seems as though my previous attempt didn't post properly somehow (when I click on it there's nothing there at all), so let's try again:
I have a table with two key fields and one data field. I need to reorganise it so that the key fields are summarised, with the data in columns against those fields, rather than in rows. It currently looks like this:
Contract | Row | Charge ID |
10914 | 1 | 1001123 |
10914 | 1 | 1001345 |
10914 | 2 | 1001234 |
10915 | 1 | 1001678 |
10915 | 2 | 1001567 |
10915 | 2 | 1001456 |
10915 | 2 | 1001012 |
<tbody>
</tbody>
... and it needs to look like this:
Contract | Row | Charge ID | Charge ID | Charge ID |
10914 | 1 | 1001123 | 1001345 | |
10914 | 2 | 1001234 | ||
10915 | 1 | 1001678 | ||
10915 | 2 | 1001567 | 1001456 | 1001012 |
<tbody>
</tbody>
... with the Charge IDs summarised by Contract and Row BUT appearing in the order in which they were originally listed. Any given contract can have between 2 and 10 Rows, and any given Row can have up to 20 Charge IDs.
I've tried this in a pivot table but it seems as though you have to aggregate your data somehow, which is not what I want. I have also had a bodge about in Power Query but I don't really know enough about it to make it work. I'm sure there's a simple solution to this but I can't get there by myself. Any help would be hugely appreciated.
Cheers
Jeff