Is it possible/How-to split data from 1 column into multiple columns for export to csv or excel?
Is it possible/How-to split data from 1 column into multiple columns for export to csv or excel?
Thank you for this incredibly useful package. Working on export using buttons and have a table where certain <td> cells have multiple rows of information separated by <br>. This is to not have such a wide table with many columns, but now for export I'd like to be able to split some of these cells into multiple rows.
For example:
<td>
example@example.com
<br>
555-555-5555
<br>
1234 Main Street
<br>
Anytown, Anyplace
</td>
Is is there a way to export this <td> into four columns (email, phone, street, city?). Thanks for any guidance. If it's not possible, that would be helpful to know as well.