Change grain of data to orderline about woocommerce-orders-google-sheets-integration HOT 1 OPEN

It gets pretty complicated to do it by script, the best u can recommend you is try using this formulas in four different groups of columns (each group has the same ammount of columns and each column represents a product)
first cell of first group/product one =SI.ERROR(ENCONTRAR(",", I2),"")
second cell of first group/product two =SI(P2="","",SI.ERROR(ENCONTRAR(",",$I2,P2+1),""))
first cell of second group/product one =SI.ERROR(IZQUIERDA($I2, P2-1),"")
second cell of first group/product two =SI.ERROR(EXTRAE($I2, P2+1, Q2-P2-1),"")
first cell of third group/product one =SI.ERROR(EXTRAE(EXTRAE(EXTRAE(SUSTITUIR(V2," ","^",3),1,256),ENCONTRAR("^",SUSTITUIR(V2," ","^",3)),256),2,ENCONTRAR(" ",EXTRAE(EXTRAE(SUSTITUIR(V2," ","^",3),1,256),ENCONTRAR("^",SUSTITUIR(V2," ","^",3)),256))-2),)
second cell of third group/product two = just drag the formula from cell 1 of this same group
first cell of fourth group/product one =SI(SI.ERROR(IZQUIERDA(V2,2),"")+0=0,"",SI.ERROR(IZQUIERDA(V2,2),"")+0)
second cell of fourth group/product two = just drag the formula from cell 1 of this same group

and a fifth group of columns on which the header of each column must have the name that will be showing on group three, and on the first cell of that group use a lookv to get the total ammount per product per line

*this i copied from a file in which i manage 6 products so thats why the columns letters dont make much sense

from woocommerce-orders-google-sheets-integration.