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.
Bookmarks