databasewolfy
New Member
- Joined
- Aug 12, 2019
- Messages
- 6
I have a spreadsheet with several hundreds of entries all separated by line breaks. How can I get the data below to look like the end result?
Thanks in advance!
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3816;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:4561;width:98pt" width="131"> </colgroup><tbody>
[TD="class: xl65, width: 64, align: left"]location[/TD]
[TD="class: xl66, width: 109, align: left"]device1[/TD]
[TD="class: xl67, width: 131, align: left"]app1
<line break>
app2
<line break>
app3
<line break>
etc…[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="class: xl66, align: left"]device2[/TD]
[TD="class: xl67, width: 131, align: left"]app1
<line break>
app2
<line break>
app3
<line break>
etc…[/TD]
[TD="align: left"]to the desired result:
[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device1[/TD]
[TD="align: left"]app1[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device1[/TD]
[TD="align: left"]app2[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device1[/TD]
[TD="align: left"]app3[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device2[/TD]
[TD="align: left"]app1[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device2[/TD]
[TD="align: left"]app2[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device2[/TD]
[TD="align: left"]app3[/TD]
</tbody>
Thanks in advance!
<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3816;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:4561;width:98pt" width="131"> </colgroup><tbody>
[TD="class: xl65, width: 64, align: left"]location[/TD]
[TD="class: xl66, width: 109, align: left"]device1[/TD]
[TD="class: xl67, width: 131, align: left"]app1
<line break>
app2
<line break>
app3
<line break>
etc…[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="class: xl66, align: left"]device2[/TD]
[TD="class: xl67, width: 131, align: left"]app1
<line break>
app2
<line break>
app3
<line break>
etc…[/TD]
[TD="align: left"]to the desired result:
[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device1[/TD]
[TD="align: left"]app1[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device1[/TD]
[TD="align: left"]app2[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device1[/TD]
[TD="align: left"]app3[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device2[/TD]
[TD="align: left"]app1[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device2[/TD]
[TD="align: left"]app2[/TD]
[TD="class: xl65, align: left"]location[/TD]
[TD="align: left"]device2[/TD]
[TD="align: left"]app3[/TD]
</tbody>