This is a bit of an odd one. I’ve done searching and so far have only come up with partial answers.
Basically I have a spreadsheet with multiple columns, each comma separated, but all relating to the same row (in this case a row is a physical product, like a t-shirt). Sample data:
Sizes: XS,S,M,L,XL,2XL,3XL,4XL
Prices: $31.40,$31.40,$31.40,$31.40,$31.40,$33.40,$35.40,$36.40
All of this data relates to one row, and creates an array of sizes & their relevant cost (e.g. XS is $31.40, 3XL is $35.40). It’s not hard to get just the sizes (I’m using a loop) but the problem is I’m not sure how I can correlate the data with the prices. The end goal is to be able to push the size and the price on the same step to a JSON endpoint (that part I have done).
Here’s what I have so far:
Best answer by MohSwellam
View original
