Generate field basing on field occurrences

asked 2016-01-17 15:52:39 +0200

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?

edit retag flag offensive close merge delete