Column Grouping within a page.

%3CLINGO-SUB%20id%3D%22lingo-sub-2121282%22%20slang%3D%22en-US%22%3EColumn%20Grouping%20within%20a%20page.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121282%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20employer%20has%20me%20make%20a%20report%20that%20takes%20about%20200%2C000%20Member%20Numbers%2C%20(5%20digit%20numbers)%20copy%20them%20from%20one%20excel%20file%2C%20all%20in%20one%20column%20to%20another%20but%20has%20me%20cut%20and%20paste%20the%20cells%20so%20that%20they%20stay%20above%20line%2038%20(for%20printing%20reasons)%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20group%20the%20columns%20and%20set%20the%20page%20break%20to%20go%20to%20the%20next%20column%20on%20the%20same%20page%20and%20not%20the%20next%20page.%20I%20have%20tried%20grouping%20but%20I%20can%20not%20get%20the%20rules%20for%20that%20consistent.%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2121282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2121428%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20Grouping%20within%20a%20page.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2121428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F963074%22%20target%3D%22_blank%22%3E%40KimD1976%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShould%20the%20report%20have%20one%20or%20more%20header%20rows%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2145177%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20Grouping%20within%20a%20page.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2145177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BI%20do%20not%20believe%20so.%20They%20want%20all%20of%20those%20numbers%20to%20go%20chronologically%20from%20top%20to%20bottom%20from%20one%20column%20to%20the%20next%20per%20page.%20So%20lets%20say%20for%20example%20%23%201-38%20are%20in%20column%20A.%2039-76%20in%20column%20B%20etc%20etc.%26nbsp%3B%20They%20do%20not%20want%20a%20new%20page%20started%20or%20printed%20until%20they%20get%20to%20the%20last%20column%2C%20typically%20J.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello. 

My employer has me make a report that takes about 200,000 Member Numbers, (5 digit numbers) copy them from one excel file, all in one column to another but has me cut and paste the cells so that they stay above line 38 (for printing reasons)

Is there a way to group the columns and set the page break to go to the next column on the same page and not the next page. I have tried grouping but I can not get the rules for that consistent. Thank you.

3 Replies

@KimD1976 

Should the report have one or more header rows?

@Hans Vogelaar I do not believe so. They want all of those numbers to go chronologically from top to bottom from one column to the next per page. So lets say for example # 1-38 are in column A. 39-76 in column B etc etc.  They do not want a new page started or printed until they get to the last column, typically J.

@KimD1976 

Let's say your data are in column A on Sheet1.

On another sheet, press F5 or Ctrl+G to activate the Go To dialog.

Enter A1:GTL38 in the box, then click OK or press Enter.

Enter the following formula and confirm it with Ctrl+Enter to fill the entire selection.

=INDEX(Sheet1!$A:$A,38*(COLUMN()-1)+MOD(ROW()-1,38)+1)