Hi all
I am trying to change this table to the next. I can sort of get there with pivot, but wonder if there is a simple method to keep the file flat?
Many thanks
<tbody>
</tbody>
<tbody>
</tbody>
Many Thanks
Phil
I am trying to change this table to the next. I can sort of get there with pivot, but wonder if there is a simple method to keep the file flat?
Many thanks
2001 | 2002 | 2003 | 2004 | ||
Area | age | number of people | number of people | number of people | number of people |
area1 | 1 year old | 100 | 107 | 108 | 112 |
area1 | 2 year old | 100 | 99 | 97 | 99 |
area1 | 3 year old | 106 | 87 | 87 | 88 |
area2 | 1 year old | 50 | 49 | 49 | 60 |
area2 | 2 year old | 39 | 40 | 41 | 42 |
area2 | 3 year old | 42 | 43 | 44 | 45 |
<tbody>
</tbody>
1 year old | 2 year old | 3 year old | ||
AREA | YEAR | number of people | number of people | number of people |
area1 | 2001 | 100 | 100 | 106 |
area1 | 2002 | 107 | 99 | 87 |
area1 | 2003 | 108 | 97 | 87 |
area1 | 2004 | 112 | 99 | 88 |
area2 | 2001 | 50 | 39 | 42 |
area2 | 2002 | 49 | 40 | 43 |
area2 | 2003 | 49 | 41 | 44 |
area2 | 2004 | 60 | 42 | 45 |
<tbody>
</tbody>
Many Thanks
Phil