Hi,
I'm new to the forum and a relatively basic user of excel, so apologies if I have posted this in the wrong place or am asking a dumb question...
I am looking for a simple and quick method to populate a column (well, 300 odd columns) with x instances of a fixed value, followed by x intances of another fixed value, and so on for a total of 13 fixed values. In my dataset I have roughly 300 rows (participants) x 13 columns (categories). Each cell represents a percent estimate of people falling within each category (such that each row always sums to 100), and estimates vary across participants. For each participant (row) I would like to sequentially populate a column with x instances (no. instances is ppt's percent estimate for category 1) of the category label (in the header row), followed by x instances (no. instances is ppt's percent estimate for category 2) of the category label, and so on. This may make more sense looking at the attached example... In columns M-O I have done this manually for ppts 1-3 to provide a sense of what I am trying to achieve. The fixed values are in the header row A-K, and are constant across ppts. So for example, ppt 1 (column m) has 10 instances of 7499.5, followed by 19 instances of 22499.5, and so on. Is there an efficient method to automatically populate a column for each ppt based on these rules?
I hope this makes sense. Any help would be much appreciated!
Thanks,
Rael
Bookmarks