Hi all.
I have a sheet in this form
+---------+--------------+
| Verb | Prep |
+---------+--------------+
| account | for (sth) |
+---------+--------------+
| ask | (so) out |
+---------+--------------+
| ask | around |
+---------+--------------+
| break | up |
+---------+--------------+
| break | up |
+---------+--------------+
| break | out |
+---------+--------------+
| break | out in (sth) |
+---------+--------------+
I’d like to insert a new column like this
+---------+--------------+-----------+
| Verb | Prep | Id |
+---------+--------------+-----------+
| account | for (sth) | account_0 |
+---------+--------------+-----------+
| ask | (so) out | ask_0 |
+---------+--------------+-----------+
| ask | around | ask_1 |
+---------+--------------+-----------+
| break | up | break_0 |
+---------+--------------+-----------+
| break | up | break_1 |
+---------+--------------+-----------+
| break | out | break_2 |
+---------+--------------+-----------+
| break | out in (sth) | break_3 |
+---------+--------------+-----------+
So, I’d like to concatenate the verb in the first column to the times that this verb was present in the fields above the current one. Is this possible?