Hi all,
I'm new here, so if this is already posted in another tread, please forgive my newbidity for not finding it.
My question is...
...is possible to merge certain cells in column B, make them wrap text every time a new cell is added to the merge, and base the merge on duplicate fields in column A?
Example.
I have a list of songs in column A which may or may not be duplicated. And when they are duplicated, it might be once, twice...even three or four times on occasion.
In column B is a descriptive category which the songs are placed. Each song may be in more than one category. I would like to somehow take the duplicate songs from column A, and also combine the categories in pertaining to that song into a single cell, but each category on a different line (using text wrap or something)
Example.
<table style="border-collapse: collapse; width: 379pt;" border="0" width="505" cellpadding="0" cellspacing="0"><col style="width: 269pt;" width="359"> <col style="width: 110pt;" width="146"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">At His Feet</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">At His Feet</td> <td class="xl66" style="width: 110pt;" width="146">Worship</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">At The Cross</td> <td class="xl66" style="width: 110pt;" width="146">Cross</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">Away In A Manger</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Away In A Manger</td> <td class="xl66" style="width: 110pt;" width="146">Christmas</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">Battle By Battle</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Assurance</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Warfare</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Faith</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Heaven</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">Battle Hymn Of The Republic</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle Hymn Of The Republic</td> <td class="xl66" style="width: 110pt;" width="146">Victory</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle Hymn Of The Republic</td> <td class="xl66" style="width: 110pt;" width="146">Warfare</td> </tr> </tbody></table>
Corrected cells:
<table style="border-collapse: collapse; width: 275pt;" border="0" width="366" cellpadding="0" cellspacing="0"><col style="width: 222pt;" width="296"> <col style="width: 53pt;" width="70"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 15.75pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="21">At His Feet</td> <td class="xl65" style="width: 53pt;" width="70">Worship</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 30pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="40">At The Cross</td> <td class="xl65" style="width: 53pt;" width="70">Cross</td> </tr> <tr style="height: 45pt;" height="60"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 45pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="60">Away In A Manger</td> <td class="xl65" style="width: 53pt;" width="70">Christmas</td> </tr> <tr style="height: 78.75pt;" height="105"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 78.75pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="105">Battle By Battle</td> <td class="xl65" style="width: 53pt;" width="70">Assurance
Warfare
Faith
Heaven</td> </tr> <tr style="height: 31.5pt;" height="42"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 31.5pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="42">Battle Hymn Of The Republic</td> <td class="xl65" style="width: 53pt;" width="70">Victory
Warfare</td> </tr> </tbody></table>
*I'm not sure why, but when I paste these cells here, column A is centering towards the middle of column B...they don't in my file.
If someone could shed some light on how to go about making this happen with a few clicks of the button and a formula or two...I'D GREATLY APPRECIATE IT!!!!
I'm new here, so if this is already posted in another tread, please forgive my newbidity for not finding it.
My question is...
...is possible to merge certain cells in column B, make them wrap text every time a new cell is added to the merge, and base the merge on duplicate fields in column A?
Example.
I have a list of songs in column A which may or may not be duplicated. And when they are duplicated, it might be once, twice...even three or four times on occasion.
In column B is a descriptive category which the songs are placed. Each song may be in more than one category. I would like to somehow take the duplicate songs from column A, and also combine the categories in pertaining to that song into a single cell, but each category on a different line (using text wrap or something)
Example.
<table style="border-collapse: collapse; width: 379pt;" border="0" width="505" cellpadding="0" cellspacing="0"><col style="width: 269pt;" width="359"> <col style="width: 110pt;" width="146"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">At His Feet</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">At His Feet</td> <td class="xl66" style="width: 110pt;" width="146">Worship</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">At The Cross</td> <td class="xl66" style="width: 110pt;" width="146">Cross</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">Away In A Manger</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Away In A Manger</td> <td class="xl66" style="width: 110pt;" width="146">Christmas</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">Battle By Battle</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Assurance</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Warfare</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Faith</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle By Battle</td> <td class="xl66" style="width: 110pt;" width="146">Heaven</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="background: red none repeat scroll 0% 0%; height: 15pt; width: 269pt; font-size: 11pt; color: black; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="20">Battle Hymn Of The Republic</td> <td class="xl65" style="width: 110pt;" width="146">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle Hymn Of The Republic</td> <td class="xl66" style="width: 110pt;" width="146">Victory</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl68" style="background: red none repeat scroll 0% 0%; height: 15.75pt; width: 269pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="359" height="21">Battle Hymn Of The Republic</td> <td class="xl66" style="width: 110pt;" width="146">Warfare</td> </tr> </tbody></table>
Corrected cells:
<table style="border-collapse: collapse; width: 275pt;" border="0" width="366" cellpadding="0" cellspacing="0"><col style="width: 222pt;" width="296"> <col style="width: 53pt;" width="70"> <tbody><tr style="height: 15.75pt;" height="21"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 15.75pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="21">At His Feet</td> <td class="xl65" style="width: 53pt;" width="70">Worship</td> </tr> <tr style="height: 30pt;" height="40"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 30pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="40">At The Cross</td> <td class="xl65" style="width: 53pt;" width="70">Cross</td> </tr> <tr style="height: 45pt;" height="60"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 45pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="60">Away In A Manger</td> <td class="xl65" style="width: 53pt;" width="70">Christmas</td> </tr> <tr style="height: 78.75pt;" height="105"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 78.75pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="105">Battle By Battle</td> <td class="xl65" style="width: 53pt;" width="70">Assurance
Warfare
Faith
Heaven</td> </tr> <tr style="height: 31.5pt;" height="42"> <td class="xl66" style="background: rgb(146, 208, 80) none repeat scroll 0% 0%; height: 31.5pt; width: 222pt; font-size: 11pt; color: windowtext; font-weight: 400; text-decoration: none; font-family: Calibri; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" width="296" height="42">Battle Hymn Of The Republic</td> <td class="xl65" style="width: 53pt;" width="70">Victory
Warfare</td> </tr> </tbody></table>
*I'm not sure why, but when I paste these cells here, column A is centering towards the middle of column B...they don't in my file.
If someone could shed some light on how to go about making this happen with a few clicks of the button and a formula or two...I'D GREATLY APPRECIATE IT!!!!