Generating List from Summarized Tables

[Tokikot]

Hi. I've seen a lot of articles about how a list of data can be summarized into neat tables in excel but what I am looking for is actually the reverse. Let's say that I have a table summarizing data (say, 3 or 4 variables or categories) about 100 individuals, and I want to generate list of 100 rows (one for each individual) based on the values on the summarized table. Is there a formula to actually do this in excel? ( I don't have any add-ons by the way). Thanks for your help and have a great day. I am not good in explaining what I really mean so I've uploaded an sample of what I want to do. Thanks.

 

[alansidman]

cannot manipulate data in a picture. please upload same in XL2BB format. If unfamiliar, click on link in my signature.