Task: A list with a small width has to be changed to a telephone-book-like list to save paper.

        A        B        C        D        E        F    
  1 Nachname Vorname  Nachname Vorname  Nachname Vorname  
  2 Bergmann Hans                                         
  3 Böse     Heike                                        
  4 Kurzhals Thorben                                      
  5 Langhans Ulf                                          
  6 Meier    Alfons                                       
  7 Merkel   Angelus                                      
  8 Müller   Albert                                       
  9 SchlämmerWilli                                        
 10 Schmidt  Bernd                                        
 11 Schröder Gerrit                                       
 12 Schulz   Thomas                                       
 13 Zipfel   Horst                                        
Small list

        A        B        C        D        E        F    
  1 Nachname Vorname  Nachname Vorname  Nachname Vorname  
  2 Bergmann Hans     Merkel   Angelus  Schulz   Thomas   
  3 Böse     Heike    Müller   Albert   Zipfel   Horst    
  4 Kurzhals Thorben  SchlämmerWilli                      
  5 Langhans Ulf      Schmidt  Bernd                      
  6 Meier    Alfons   Schröder Gerrit                     
  7                                                       
Version 1: 5 entries per page high, 3 wide

        A        B        C        D        E        F    
  1 Nachname Vorname  Nachname Vorname  Nachname Vorname  
  2 Bergmann Hans     Langhans Ulf      Müller   Albert   
  3 Böse     Heike    Meier    Alfons   SchlämmerWilli    
  4 Kurzhals Thorben  Merkel   Angelus  Schmidt  Bernd    
  5 Schröder Gerrit                                       
  6 Schulz   Thomas                                       
  7 Zipfel   Horst                                        
  8                                                       
Version 2: 3 entries per page high, 3 wide

                            A                              B        C    D  
  1 Parameter                                         for         Name Value
  2 Output lines per page (page length)               Target      ApS     5 
  3 Columns of the list                               Src/Tgt     SpL     2 
  4 Lists on page              (Source=1)             Target      LpS     3 
  5 Data offset from row 1 (for title)                Source      QV      1 
  6 Data offset from row 1 (for title)                Target      ZV      1 
  7 Data offset from column 1 (for title or other)    Source      QW      0 
  8 Data offset from column 1 (for title or other)    Target      ZW      0 
  9 Range of Source!A:IV                              Source      Q     n.a.
Legend of used names in formula

Solution (see also File):

=INDEX(Q,QV+ROW()-ZV+(INT((COLUMN()-1%-ZW)/SpL)+INT((ROW()-ZV-1)/ApS)*(LpS-1))*ApS,QW+MOD(COLUMN()-1%-ZW,SpL)+1%)

The legends values refer to version 1. Version 2 uses ApS = 5. Note: Version 2 uses two pages instead of one.

Remarks: Copy formula into output sheet. Don't overwrite titles or other fix contents. Define titles in Excel and consider them in legend (Line 5 to 8), where in the example row title amounts to 1 (line) each. There are no column titles used, so in the example they both amount to 0. Adjust length of page (ApS) manually for desired print or preview result.