SOLVED
Count combination of two words in comma separated column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
StephenJPSheehan
7 - Meteor
‎10-31-2022
09:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am looking to try and count the combinations of two countries, separated by commas, in order to form a matrix. The data I am looking at is based on hurricane landfall per country.
Please see the attached spreadsheet which has an extract of the original data and the desired output.
I've tried a few different ways with the Transpose/Summarize functions but haven't quite cracked it! Any help would be greatly appreciated.
Thanks,
Stephen
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
- Transformation
4 REPLIES 4
Felipe_Ribeir0
16 - Nebula
‎10-31-2022
09:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Felipe_Ribeir0
16 - Nebula
‎11-03-2022
04:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
KrishnaChithrathil
11 - Bolide
‎11-03-2022
06:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
had to refer your code just to understand the scenario. 😄
‎11-03-2022
06:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Felipe_Ribeir0 - your solution did work, thank you for your help!
