hi guys
So im working on large data sets with about 2000 entries. i want to be able to 'decompose' the multiple entry fields so that they fall in the right places ( with 1 count for 1 unique name) an example
my spreadsheet
Name Location for holiday
David bantry bay
Jonathan bantry bay, sea point, fresnaye
Joseph sea point, greenpoint
Jeremih sea point
Rosa greenoint
Chris greenpoint
Roy sea point, fresnaye
what the pivot table gives me
Location for holiday count
bantry bay 1
bantry bay, sea point, fresnaye 1
sea point, greenpoint 1
sea point 1
greenoint 2
sea point, fresnaye 1
what i would like to see
location for holiday count
bantry bay 2
sea point 4
fresnaye 2
greenpoint 2
i am dealing with large data sets with multiple variations in that particular "location for holiday" entry. Your help would be appreciated
So im working on large data sets with about 2000 entries. i want to be able to 'decompose' the multiple entry fields so that they fall in the right places ( with 1 count for 1 unique name) an example
my spreadsheet
Name Location for holiday
David bantry bay
Jonathan bantry bay, sea point, fresnaye
Joseph sea point, greenpoint
Jeremih sea point
Rosa greenoint
Chris greenpoint
Roy sea point, fresnaye
what the pivot table gives me
Location for holiday count
bantry bay 1
bantry bay, sea point, fresnaye 1
sea point, greenpoint 1
sea point 1
greenoint 2
sea point, fresnaye 1
what i would like to see
location for holiday count
bantry bay 2
sea point 4
fresnaye 2
greenpoint 2
i am dealing with large data sets with multiple variations in that particular "location for holiday" entry. Your help would be appreciated