I am currently working on a project where I need some data organization help. My high level goal is I want to create an order management process. In this process orders will automatically come in through a web-hook to the google sheet. I then want a list of products for the employee to go pick the products. Essentially when an order comes in it goes to a google sheet as its own row so the google sheet will have 1 row but will have product 1 quantity 1 Product 2 quantity 2 Product 3 quantity 3 and so on. I want to be able to update each individual product status. To do this I need to create a new google sheet that takes the rows with multiple columns of products and puts it into a vertical table. So instead you would just have product & quantity and each row is one of the products from the previous spreadsheet. I am struggling with this part as you can’t do a simple lookup as there could be 3 products an order or 15 products an order and when multiple orders come in it would not allow the formulas work.
Does anyone have any ideas??