generate numbers for rows based on condition

[xariet]

Hi All

I am currently working with a table that contains transaction names. Within this table, there are 16 occurrences of each transaction type. I have a specific requirement where I need to create a new column and assign the value "assets" to the first 8 occurrences of each transaction type, and the value "liability" to the remaining 8 occurrences. I was thinking if I can use the tile tool and assign numbers from 1 to 16 to each transaction type and then use the formula tool to assign values based on conditions from 1 to 8 and from 9 to 16. But I am struggling to configure the tile tool to achieve this result. Any ideas maybe to use another approach?

thank you 

[Qiu · Accepted solution]

@xariet 
Maybe you missed the "Group by Columns" option? 😁