Advertisements
I need to generate "ID" in quantity which is given in "quantity" column.
I use the formula "=ArrayFormula(TOCOL("T"&TEXT( sequence(C2);"00")&""&$A2&"|"&$B2))".
It generates ID only for the first product. How to generate IDs for the entire ID array?
Example file
>Solution :
You may try:
=tocol(map(A2:A;B2:B;C2:C;lambda(a;b;c;if(counta({a\b\c})<>3;;index("T"&text(sequence(1;c);"00")&a&"|"&b))));1)