Hi All,
I've been searching the forum, but haven't been able to find exactly what I need.
I need a macro that gives below result, hope anyone can help.
Data:
<tbody>
</tbody>
Result:
<tbody>
</tbody>Regards
Skovgaard
I've been searching the forum, but haven't been able to find exactly what I need.
I need a macro that gives below result, hope anyone can help.
Data:
Jan | Feb | Mar | ||
P1 | Q1 | 75 | 100 | 125 |
P2 | Q2 | 30 | 40 | 50 |
P3 | Q2 | 10 | 40 | 70 |
<tbody>
</tbody>
Result:
P1 | Q1 | Jan | 75 |
P1 | Q1 | Feb | 100 |
P1 | Q1 | Mar | 125 |
P2 | Q2 | Jan | 30 |
P2 | Q2 | Feb | 40 |
P2 | Q2 | Mar | 50 |
P3 | Q2 | Jan | 10 |
P3 | Q2 | Feb | 40 |
P3 | Q2 | Mar | 70 |
<tbody>
</tbody>
Skovgaard