Populating a table based on percentages and total population

[nukeemaway]

Hope everybody is having a good day. Hopefully someone will be able to help me.

I have the results derived from a database, but do not have access to the original raw file. The file that I have gives me the percentage totals and the total counts.

As a simplified example, I know that for category X I have 100 responses. 10 people answered 1, 20 people answered 2, 30 people answered 3, and 40 people answered 4. Thus, on my excel file, column A rows 1-4 lists 1, 2, 3, 4 and the corresponding entries in column B are 10%, 20%, 30%, 40%.

My actual sheet is more complex, and has numerous categories going down the sheet, but the setup is essentially the same. Is there a way that I can quickly populate a table based on just this? In other words, using these percentages, can I quickly fill up a table that will have ten 1's, twenty 2's, thirty 3's, and forty 4's (more specifically, the numbers from my actual file) so that I can run the necessary tests on them (e.g. mean, mode, median, standard deviation, etc.)?

Thanks a lot.

 

[GDS]

Are the number of respondants consistent or does it vary per category?

 

[nukeemaway]

It varies. The totals are in the row directly below the percentages.

 

[GDS]

Then you don't really need to extrapulate each number into the corresponding number of 1 each in a unique cell. You just need to times the total by the percentages to give you the total number in column C and have a running total in column D and the difference in the running total in E

 

[nukeemaway]

The thing is that I would like to be able to use excel's built in tools to calculate things like standard deviation, etc., which unless I'm mistaken, are based off of the list of the individual numbers.