Hi,
I have a set of data - example below - which I need sorting to show each day there is a delivery in the same postcode all on the same line;
Data set example -
<tbody>
</tbody>
I need the following layout but just 1 row with the post code and all delivery days to the right transposed;
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
I tried pivot tables but the values [FONT="]use one of the aggregation functions SUM, COUNT, MIN, AVERAGE etc., so it is always a number.[/FONT]
Help please
Thanks
I have a set of data - example below - which I need sorting to show each day there is a delivery in the same postcode all on the same line;
Data set example -
Postcode | Route | Drop | Delivery Day | |
AB12 3ZG |
<tbody> </tbody> | 25 | Wednesday | |
AB12 3ZG |
<tbody> </tbody> | 25 | Saturday | |
AB24 5EZ | H1006 | 1 | Wednesday | |
AB24 5EZ | H1006 | 1 | Saturday | |
AL1 4PL | H1006 | 90 | Monday | |
AL1 4PL | H1006 | 90 | Wednesday | |
AL4 0LL | H1006 | 100 | Monday | |
AL4 0LL | H1006 | 100 | Wednesday | |
AL4 0LL | H1006 | 100 | Friday |
<tbody>
</tbody>
I need the following layout but just 1 row with the post code and all delivery days to the right transposed;
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
Postcode | Route | Drop | Delivery Day | Delivery Day | Delivery Day | |
AB12 3ZG |
<tbody> </tbody> | 25 | Wednesday | Saturday | ||
AB24 5EZ | N3700 | 1 | Wednesday | Saturday | ||
AL1 4PL | H1006 | 90 | Monday | Wednesday | ||
AL4 0LL | H1006 | 100 | Monday | Wednesday | Friday |
<tbody>
</tbody>
I tried pivot tables but the values [FONT="]use one of the aggregation functions SUM, COUNT, MIN, AVERAGE etc., so it is always a number.[/FONT]
Help please
Thanks