tryingmybest418
New Member
- Joined
- Jan 22, 2018
- Messages
- 32
I have a column of information and would like to find a way to translate it into rows using VBA. Every 3-7 rows in my existing column has a cell "New Record". I'd like the information below that cell to be laid out in a new row.
Currently:
<tbody>
</tbody>
Would Like:
<tbody>
</tbody>
Thank you!
Currently:
New Record | |
4756 | |
John Doe | |
123 Street Ave. | |
Chicago, Illinois | |
451002 | |
481002 | |
New Record | |
4869 | |
Jane Doe | |
0 | |
0 | |
New Record | |
5012 | |
Jim Thompson | |
456 Street Ave. | |
New York, New York | |
451005 | |
481005 |
<tbody>
</tbody>
Would Like:
New Record | 4756 | John Doe | 123 Street Ave. | Chicago, Illinois | 451002 | 481002 |
New Record | 4869 | Jane Doe | 0 | 0 | ||
New Record | 5012 | Jim Thompson | 456 Street Ave. | New York, New York | 451005 | 481005 |
<tbody>
</tbody>
Thank you!