FirstWorldAnalyst
New Member
- Joined
- Apr 13, 2018
- Messages
- 2
Hi All!
First off, I apologize at my horrible attempt to title this thread - I'm sure there's a much better way to word it. I'm pretty stumped on this one. I'm working with a fairly large database (~5K rows) of reservation numbers & email addresses. Please forgive my poor attempt at describing my problem:
I have two columns to work with, "Reservation Numbers" & "Email Addresses". If there's one email address per reservation number, they'll line up in the same row. However, if there are two or more emails assigned to a reservation number, an extra row is inserted with a (blank) in the reservation number column. I'm trying to branch out "Emails" column into new rows but also aligned with the correct "Reservation Number" row.
I'm trying to turn this:
<colgroup><col><col></colgroup><tbody>
</tbody>
Into this:
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
I hope this all makes sense. Thank you for taking the time to read through and I look forward to any/all replies!
Thank you, again!
First off, I apologize at my horrible attempt to title this thread - I'm sure there's a much better way to word it. I'm pretty stumped on this one. I'm working with a fairly large database (~5K rows) of reservation numbers & email addresses. Please forgive my poor attempt at describing my problem:
I have two columns to work with, "Reservation Numbers" & "Email Addresses". If there's one email address per reservation number, they'll line up in the same row. However, if there are two or more emails assigned to a reservation number, an extra row is inserted with a (blank) in the reservation number column. I'm trying to branch out "Emails" column into new rows but also aligned with the correct "Reservation Number" row.
I'm trying to turn this:
Reservation Numbers | Email Addresses |
10010 | jo.bob@gmail.com |
10011 | amy.smith@gmail.com |
george.robinson@gmail.com | |
tom.nelson@gmail.com | |
10012 | jacob.riely@gmail.com |
nathan.brown@gmail.com |
<colgroup><col><col></colgroup><tbody>
</tbody>
Into this:
Reservation Numbers | Email Addresses | ||
10010 | jo.bob@gmail.com | ||
10011 | amy.smith@gmail.com | george.robinson@gmail.com | tom.nelson@gmail.com |
10012 | jacob.riely@gmail.com | nathan.brown@gmail.com |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
I hope this all makes sense. Thank you for taking the time to read through and I look forward to any/all replies!
Thank you, again!