I have a excel sheet that has products purchased, that looks like this:
| product 1 name |
product 1 amount |
product 2 name |
product 2 amount |
product 3 name |
product 3 amount |
| banana |
10 |
apple |
5 |
pineapple |
2 |
| apple |
0 |
banana |
6 |
pineapple |
4 |
| pineapple |
5 |
banana |
10 |
apple |
11 |
I want to have a fields such as banana_amount, apple_amount, and pineapple_amount instead of having to do set expressions to see totals
How would I do that in the load script?
