+ Reply to Thread
Results 1 to 2 of 2

Using a function to take a list and divide it into two columns

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    Spencer, IA
    MS-Off Ver
    Office 2010
    Posts
    13

    Using a function to take a list and divide it into two columns

    I'm going to set this up as best as I can to explain what I am looking to do.

    If I have column A have model names in alphabetical order, column B has the model code, and column C has the rate.

    I want to go to another sheet in the excel document and retrieve this list but print them alternating, so the first item in the list is across column A, B, and then C. The second item on the list will print across E, F, and G. Column D is a buffer to separate the two columns. The third item will be under the first item in column A, B, and C again. And so on.

    The list:
    Model 1, Model Code 1, Model Rate 1
    Model 2, Model Code 2, Model Rate 2
    Model 3, Model Code 3, Model Rate 3
    Model 4, Model Code 4, Model Rate 4
    Model 3, Model Code 5, Model Rate 5
    Model 4, Model Code 6, Model Rate 6
    Etc...

    The way I want to print the list:
    [Model 1][Model Code 1][Model Rate 1][ ][Model 2][Model Code 2][Model Rate 2]
    [Model 3][Model Code 3][Model Rate 3][ ][Model 4][Model Code 4][Model Rate 4]
    [Model 5][Model Code 5][Model Rate 5][ ][Model 6][Model Code 6][Model Rate 6]

    I can type each square to manually get each cell, but that is not practical for 1000 entries. I cannot think of an easy function to use and fill down from one entry to alternate the list the way I am seeking. I hope this makes sense and someone can guide me to a function to do just that. And before everyone thinks I'm being lazy, I am not sure how to word it properly to find it on google search. I promise I tried, but I get lots of threads either showing how to round an even or odd number, or how to use the sort command. I just want a function to put in the top row of each of the 6 columns to autofill the list down. Please help me and thank you in advance.
    Last edited by fjyoder; 04-27-2015 at 04:41 PM.

  2. #2
    Registered User
    Join Date
    04-24-2015
    Location
    Spencer, IA
    MS-Off Ver
    Office 2010
    Posts
    13

    Re: Using a function to take a list and divide it into two columns

    To add, the first list is in a sheet named "Color_Wall" starting in Cell A5 down to C1000. The second list will be on a sheet name "Rate_Sheet" starting in cell A1 down to F996. Remember column D is blank to provide a buffer down the middle of the list. Both are in the same document.
    Last edited by fjyoder; 04-27-2015 at 04:37 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. To divide value in each cell to the sum of the corresponding columns.
    By DanaGaraf in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 06:13 AM
  2. Divide a list
    By arpanjain01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2012, 10:10 PM
  3. Divide columns with an if
    By allykid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2011, 03:25 PM
  4. Divide columns
    By antony moseley in forum Access Tables & Databases
    Replies: 3
    Last Post: 06-08-2010, 12:46 PM
  5. Divide all combinations from 2 columns
    By pempey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2008, 04:07 PM

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