Was wondering what's the best way to go about being able to burst a data row into multiple rows (like lower level of detail) that would sum to the original data row if you have the variable for the burst # of rows?
For example: If I have this data
Grocery Aisle # | # of Shelves | # of Products --> With # of Shelves as my variable to burst to the # of rows
1 2 4
2 3 9
How do I use Alteryx to produce this:
Grocery Aisle # | # of Shelves | # of Products
1 1 2 --> Aisle 1 was divided into 2 (# of Shelves); Sum of Products still at 4 Total
1 1 2
2 1 3 --> Aisle 2 was divided into 3 (# of Shelves); Sum of Products still at 9 Total
2 1 3
2 1 3
