Hi there,
I have a table below that consists of a list of projects in column A and on each row values are input representing year on year costs. I would like to put Table 1 in a list format as shown in Table 2. These are examples and the reality is that I have a lot of data to re-format and I'm thinking that an OFFSET formula would assist in this?
Table 1
<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;">
<col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;" span="6">
<tbody>
</tbody>
Table 2
<colgroup><col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;">
<col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;" span="6">
<tbody>
</tbody>
Any help would be appreciated.
Regards
Ben
I have a table below that consists of a list of projects in column A and on each row values are input representing year on year costs. I would like to put Table 1 in a list format as shown in Table 2. These are examples and the reality is that I have a lot of data to re-format and I'm thinking that an OFFSET formula would assist in this?
Table 1
A | B | C | D | E | F | |
1 | Project | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
2 | A | £500 | £100 | £300 | £0 | £500 |
3 | B | £0 | £200 | £300 | £600 | £0 |
4 | C | £0 | £0 | £450 | £450 | £800 |
5 | ||||||
6 | ||||||
7 |
Table 2
A | B | C | D | E | F | |
1 | Project | Year | Value | |||
2 | A | 1 | £500 | |||
3 | A | 2 | £100 | |||
4 | A | 3 | £300 | |||
5 | A | 4 | £0 | |||
6 | A | 5 | £500 | |||
7 | B | 1 | £0 |
Any help would be appreciated.
Regards
Ben