I need to create mini sequences and then concatenate it to the order number on some data I am parsing through Coda. Does anyone know how to do this?
My raw data has order numbers in rows. If one order has multiple items, then it has multiple rows so it would look like:
But I need a separate column that enumerates how many lines (items) in each order with a dash, this column would looke like this:
001-1 → Order with two items in it
002-1 → Order with three items in it
Is there a coda formula that could count, sequence and concatenate the duplicate rows to achieve this result? The blue highlighted column was manually entered to represent the end result I’m looking to achieve.