Hi all,
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:
001
001
002
002
002
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
001-2
002-1 → Order with three items in it
002-2
002-3
etc…
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.
