+ Reply to Thread
Results 1 to 1 of 1

Autofill columns sequentially with x instances of cell value, followed by x instances of..

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Canterbury, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Autofill columns sequentially with x instances of cell value, followed by x instances of..

    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
    Attached Files Attached Files
    Last edited by Rael Dawtry; 04-11-2013 at 12:15 PM. Reason: sorry, wrong SS!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1