I am hoping someone can help me solve this formatting issue I have. I need to be able to take the data I receive in the following format:
<tbody>
</tbody>
...and convert it to this format:
<tbody>
</tbody>
If I consider the 3 lines of original data to be 1 "record", the file I receive initially has hundreds of "records." The format of the original data will always be 2 columns and 3 rows. Is there a macros that can be created to help streamline this process? I'd truly appreciate any assistance given. (I also apologize, I don't have a full version of Excel at home and I'm not able to install anything on my work computer.)
John Smith | (111) 111-1111 |
111 Any Road | (222) 222-2222 |
Anytown, NY 11111 | anyemail@anyemail.com |
<tbody>
</tbody>
...and convert it to this format:
John Smith | 111 Any Road | Anytown, NY 11111 | (111) 111-1111 | (222) 222-2222 | anyemail@anyemail.com |
<tbody>
</tbody>
If I consider the 3 lines of original data to be 1 "record", the file I receive initially has hundreds of "records." The format of the original data will always be 2 columns and 3 rows. Is there a macros that can be created to help streamline this process? I'd truly appreciate any assistance given. (I also apologize, I don't have a full version of Excel at home and I'm not able to install anything on my work computer.)