need macro help - text extraction from cell with line breaks

[databasewolfy]

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>

 

[Fluff]

You can use text to columns to spli out col C & then use the macro I supplied in your other post.

 

[databasewolfy]

You can use text to columns to spli out col C & then use the macro I supplied in your other post.

Yeah. Apparently CTRL+J means linebreak. Not like there can be a nice little option for it. Many thanks for your help. Got it all figured out.

 

[Fluff]

Glad you sorted it & thanks for the feedback