Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
Hi I have an excel sheet - the Data in the sheets are as - a single cell contains multiple lines of data - I wanna split the lines within the cell in to separate row -
<tbody>
</tbody>Likewise each cell data split into separate columns,
Thank you - Please help
Phil Ross Mc Lean David Ross Andrews Matthew Anders Sandra | 21359877 25789563 4879652 2147631 24178965 | email1 email2 email3 email4 email5 |
Requirement | ||
Phil Ross | 21359877 | email1 |
<tbody>
</tbody>
Thank you - Please help