Not sure if that title is the snappiest way to label this query.
I have results from a questionnaire which are partly about jurisdictions of interest of businesses. As shown (poorly) below, they way they have been pulled in to excel makes it quite difficult to interact with them. The businesses appear in column one as the first entry in a row and then the rest of the row are the jurisdictions. I am especially interested in using the 3d maps feature here.
Is there a way/what is the best way to get this awkward layout of data into a place where i can interact with it more easily (pivot tables, 3d maps etc.) ???.
I tried using the go to BLANKS and deleting them but this messed with the data layout and attributed some answers to business who didnt give that answer etc.
There are too many rows to individually drag into the layer sections of 3d maps. I want 3d maps to recognise that i have a bunch of business who have each given a list of jurisdictions and be able to show this on the map and heatmap those which were mentioned most often.
Any light to be shed???
Thanks in advance!!
<tbody>
</tbody>
I have results from a questionnaire which are partly about jurisdictions of interest of businesses. As shown (poorly) below, they way they have been pulled in to excel makes it quite difficult to interact with them. The businesses appear in column one as the first entry in a row and then the rest of the row are the jurisdictions. I am especially interested in using the 3d maps feature here.
Is there a way/what is the best way to get this awkward layout of data into a place where i can interact with it more easily (pivot tables, 3d maps etc.) ???.
I tried using the go to BLANKS and deleting them but this messed with the data layout and attributed some answers to business who didnt give that answer etc.
There are too many rows to individually drag into the layer sections of 3d maps. I want 3d maps to recognise that i have a bunch of business who have each given a list of jurisdictions and be able to show this on the map and heatmap those which were mentioned most often.
Any light to be shed???
Thanks in advance!!
1 | spain | greece | iran | ||||||
2 | america | india | afghan | ||||||
3 | france | italy | czech rep | spain | india | UK | |||
4 |
<tbody>
</tbody>
Last edited: