blumfeld0

02-26-2013, 05:55 PM

Hi!

I am doing a project at work and because the data is proprietary I can't post the actual. Here is the issue:

I have one column and thousands of rows (with values between 0 and 100) and another column with the same amount of rows with labels. Please see the sample attached spreadsheet. The problem is that the second column has hundreds of labels with each numerical value. I want to do a few calculations but first I want the data presented in a way such that each numerical value matches the corresponding label.

I think the attached spreadsheet will explain everything. Please let me know if you can help. Please keep me in mind that I need to do for data which has 2 columns and thousands of rows (and hundreds of different labels).

I would greatly appreciate any assistance. Thank you!

I am doing a project at work and because the data is proprietary I can't post the actual. Here is the issue:

I have one column and thousands of rows (with values between 0 and 100) and another column with the same amount of rows with labels. Please see the sample attached spreadsheet. The problem is that the second column has hundreds of labels with each numerical value. I want to do a few calculations but first I want the data presented in a way such that each numerical value matches the corresponding label.

I think the attached spreadsheet will explain everything. Please let me know if you can help. Please keep me in mind that I need to do for data which has 2 columns and thousands of rows (and hundreds of different labels).

I would greatly appreciate any assistance. Thank you!