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>
</tbody>
Thanks in advance!
location | device1 | app1 <line break> app2 <line break> app3 <line break> etc… |
location | device2 | app1 <line break> app2 <line break> app3 <line break> etc… |
to the desired result: | ||
location | device1 | app1 |
location | device1 | app2 |
location | device1 | app3 |
location | device2 | app1 |
location | device2 | app2 |
location | device2 | app3 |
<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>
</tbody>