Hi All,
Wondering if any of you out there could help with a problem I have in re-arranging some columns and rows.
Below is an example of the data as it is:
<tbody>
</tbody>
I am needing to have the data organised like:
<tbody>
</tbody>
Help !
Any solutions would be GREATLY appreciated
Wondering if any of you out there could help with a problem I have in re-arranging some columns and rows.
Below is an example of the data as it is:
Customer | FR | DFL | TP | DLG |
A | 5 | 1 | 0 | 32 |
B | 10 | 20 | 30 | 14 |
<tbody>
</tbody>
I am needing to have the data organised like:
Customer | Product | Amount |
A | FR | 5 |
A | DFL | 1 |
A | TP | 0 |
A | DLG | 32 |
B | FR | 5 |
B | DFL | 16 |
B | TP | 20 |
B | DLG | 19 |
<tbody>
</tbody>
Help !
Any solutions would be GREATLY appreciated