Hi Guys,
I basically have a column of data made up of 0's and names of places.
In the column adjacent and to the right of it I wish to return all of the words in the column but not the 0's. If possible I want to be able to return only one of each individual word and then in the cell adjacent to this (2 columns over from the original data) tally them up
<tbody>
</tbody>
This is what I want it to look like in the end, although i have thousands of bits of data in column 1.
if anyone could help out with this i'd be grateful!
I basically have a column of data made up of 0's and names of places.
In the column adjacent and to the right of it I wish to return all of the words in the column but not the 0's. If possible I want to be able to return only one of each individual word and then in the cell adjacent to this (2 columns over from the original data) tally them up
Original Data | Places | Number of. |
Glasgow | Glasgow | 3 |
0 | London | 2 |
London | Birmingham | 2 |
London | ||
Birmingham | ||
0 | ||
Glasgow | ||
Birmingham | ||
Glasgow |
<tbody>
</tbody>
This is what I want it to look like in the end, although i have thousands of bits of data in column 1.
if anyone could help out with this i'd be grateful!