We have an excel spreadsheet with 167 columns and almost 200,000 rows.
We are trying to find a method to find the unique identifiers and the frequency in each column and save the values to a new table.
Color-I Color-C State-I State-C
Red 2 WI 2
Blue 1 IL 3
Yellow 1 TX 1
This can be done in Excel, Access, SQL....
I have attached a spreadsheet with an example of what I am looking for. The data tab is the source. The Analysis tab is the desired result.
26 freelancers are bidding on average $69 for this job
Hi, Kindly see PM, you can find your final product there, Hope you will contact me for any help for it. Thank you in advance your satisfaction is my success muthumuni