Transpose?

[gcotterl]

My data looks like this:

name
address
city
state
zip

name
address
city
state
zip

name
address
city
state
zip

name
address
city
state
zip

============================================

How can I get the data in each block onto the same line so the result looks like this:

name address city state zip
name address city state zip
name address city state zip
name address city state zip

[ben_josephs]

Search | Replace... (<F8>):

Find what: (.*)\r(.*)\r(.*)\r(.*)\r(.*)\r\r
Replace with: $1 $2 $3 $4 $5\r

[X] Regular expression

Replace All

[gcotterl]

Thank you!!!

[jeffy]

If it's that strictly formatted, a macro would work as well. Just record and run with word-wrap off.