hi,
i have several spreadsheets containing daily inventory with each file containing the inventory for all the days of the month similar to the following:
| item |
1/1/2022 |
1/2/2022 |
1/3/2022 |
1/4/2022 |
1/5/2022 |
1/6/2022 |
| a |
100 |
0 |
0 |
0 |
0 |
0 |
| a |
100 |
200 |
0 |
0 |
0 |
0 |
| a |
100 |
200 |
300 |
0 |
0 |
0 |
| b |
50 |
0 |
0 |
0 |
0 |
0 |
| b |
50 |
75 |
0 |
0 |
0 |
0 |
would it be possible to convert the above table to the following format via load script?
| item |
date |
qty |
| a |
1/1/2022 |
100 |
| a |
1/2/2022 |
200 |
| a |
1/3/2022 |
300 |
| b |
1/1/2022 |
50 |
| b |
1/2/2022 |
75 |
would appreciate if anybody can help.
Thanks
