I have a large dataset with product related data in different columns for each data.
<tbody>
</tbody>
I want to make it columner base dataset similar below table.
<tbody>
</tbody>
Is there a way to do this.
Thanks for your time & efforts.
Regards,
Klllmmm
Date | Product A | Product A | Product B | Product B |
Qty | Value | Qty | Value | |
01-09-2017 | 50 | 1000 | 40 | 800 |
02-09-2017 | 60 | 1200 | 20 | 400 |
<tbody>
</tbody>
I want to make it columner base dataset similar below table.
Date | Product | Qty | Value |
01-09-2017 | Product A | 50 | 1000 |
01-09-2017 | Product B | 40 | 800 |
02-09-2017 | Product A | 60 | 1200 |
02-09-2017 | Product B | 20 | 400 |
<tbody>
</tbody>
Is there a way to do this.
Thanks for your time & efforts.
Regards,
Klllmmm