Hi,
I have a table with several "totals" (per Q/Year) which I would like to convert into a raw data report with just one "totals" column and one Q/Year column.
Basically it's converting the below table
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
into
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks in advance!
I have a table with several "totals" (per Q/Year) which I would like to convert into a raw data report with just one "totals" column and one Q/Year column.
Basically it's converting the below table
Product | 2014 | 2015 |
bicycles | 5 | 8 |
cars | 10 | 11 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
into
Product | Year | Amount |
bicycles | 2014 | 5 |
bicycles | 2015 | 8 |
cars | 2014 | 10 |
cars | 2015 | 11 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks in advance!