Screen Shot 2017-04-19 at 21.51.59.png


Hello All,

Hoping someone can offer up and logical solution. I have a data sample as shown in the attachment.
I need to summarise the data so that I end up with two columns. Column 1 - Scene, and Column 2 - Cast No.

For Example:

Scene Cast No.
Sc. 1.1 1
Sc. 1.2 1
Sc. 1.2 20
Sc. 1.2 21
Sc. 1.2 24
Sc. 1.11 26
Sc. 1.12 1

Obviously this is just a small data set so it is easy to do manually but the actual document has 100's of rows of data.

Thanks in advance.