I am trying to move information that is pulled from a database to look cleaner and easier to read. All of the information exports out into column A only. The attachment is a brief example of what it looks like, and what I’m trying to get it to look like.

There are a couple thousand sets of information, and their much longer. Each one has 58 lines plus the blank separator row.

I have some basic experience with formulas and macros, but I haven’t had any luck trying to manipulate any of them to give me the information the way I have shown. I would prefer to not have to manually type or cut and past the information in if possible.

Thanks to anyone who can assist.

There are a couple thousand sets of information, and their much longer. Each one has 58 lines plus the blank separator row.

I have some basic experience with formulas and macros, but I haven’t had any luck trying to manipulate any of them to give me the information the way I have shown. I would prefer to not have to manually type or cut and past the information in if possible.

Thanks to anyone who can assist.

## Comment