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 post is a bit confusing...
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 value in the header row, followed by x instances (no. instances is ppt's percent estimate for category 2) of the value in the header row, and so on for all 13 cells, for each ppt. 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 A1-K1, 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
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 post is a bit confusing...
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 value in the header row, followed by x instances (no. instances is ppt's percent estimate for category 2) of the value in the header row, and so on for all 13 cells, for each ppt. 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 A1-K1, 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