Community

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

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

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

[X] Regular expression

Replace All

Thank you!!!

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