One way:

In a second sheet (assuming your list is on Sheet1), enter in A1:

=IF(MOD(ROW(),6),OFFSET(Sheet1!$A$1,INT((ROW()-1)/6), MOD(ROW()-1,6)),"")

Copy down as far as necessary. Select column A. Copy it. Choose
Edit/Paste Special, selecting the Values radio button.

In article ,
"R B via OfficeKB.com" wrote:

Hi, I made a spreadsheet of addresses with the rows formatted across as:
name, address, city, state, zip.
name2,address2,city2,state2,zip2
However, now I would like to change the format to

name,
address,
city,
state,
zip
<space
name2,
address2,
..
..
of each person.

Does anyone know how to do this? Thanks!