I am looking to create a new row based on a product being purchased 3 times in a transaction. So current record has product code with a quantity of 3 but I need each quantity on its own line/record. I feel like if I can get the REPT converted to list format then I could use the EXPAND function to accomplish the 3 individual rows/records.
Any ideas how to get REPT string results into a list?
example: REPT string result = 243074622430746224307462
desired result = [24307462,24307462,24307462]
Please sign in to leave a comment.