madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hello Folks. I used to export tables in PDF to excel. Sometimes all the words in the columns saved as a single cell. This cell is always the last used row. Each word is separated by space and Dot (.) in their respective columns. Now i want to move the words downward in their respective columns i.e C and I.The I column used to start with dot. The word should separate with dots and move to the cells below. See the example below. I know its a hectic task. Please heads up. Thank you.
<tbody>
</tbody>
Result
<tbody>
</tbody>
C | I |
XXXX | AAAA |
YYYY | BBBB |
ZZZZ | CCCC |
John Harry James Anna | ..Maths .Science ..English ...History |
<tbody>
</tbody>
Result
C | I |
XXXX | AAAA |
YYYY | BBBB |
ZZZZ | CCCC |
John | ..Maths |
Harry | .Science |
James | ..English |
Anna | ...History |
<tbody>
</tbody>