So this has often perplexed me... I have a t...

[Zachary_Gatch1]

So this has often perplexed me…

I have a tremendous amount of collected data in cells that was gathered via an enumlist input.

As most of your should know, the data is in each cell of the record like:

x , y , z.

I can easily analyze the information collected by an enum input, but how do I do so without manually doing this “by hand”.

Are there any postings that can help with this, videos?

Is there 3rd party software that can perform a function like this?

Here is a picture of the data collected by my app and an enumlist that I need to perform some analysis on.

Any information that can be shared ASAP is greatly appreciated!

Thank you.

[Zachary_Gatch1]

UPDATE:

I was able to get all responses into their own cells through text-to-columns…

Now, how can I analyze this like I would do in a pivot table?

[Bellave_Jayaram]

@Zachary_Gatch1 not sure what you mean by analyze. You want to figure out counts, frequencies, commonalities, correlations or something else?

[Lynn]

Hi, What do you want to do with it? You will probably need column headers before you can do anything. What do you want it to look like when all done?

You could use formulas, queries, scripts, macros, pivot tables…