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.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]C
[/TD]
[TD="align: center"]I
[/TD]
[/TR]
[TR]
[TD="align: center"]XXXX
[/TD]
[TD="align: center"]AAAA
[/TD]
[/TR]
[TR]
[TD="align: center"]YYYY
[/TD]
[TD="align: center"]BBBB
[/TD]
[/TR]
[TR]
[TD="align: center"]ZZZZ
[/TD]
[TD="align: center"]CCCC
[/TD]
[/TR]
[TR]
[TD="align: center"]John Harry James Anna
[/TD]
[TD="align: center"]..Maths .Science ..English ...History
[/TD]
[/TR]
</tbody>[/TABLE]
Result
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]C
[/TD]
[TD="align: center"]I
[/TD]
[/TR]
[TR]
[TD="align: center"]XXXX
[/TD]
[TD="align: center"]AAAA
[/TD]
[/TR]
[TR]
[TD="align: center"]YYYY
[/TD]
[TD="align: center"]BBBB
[/TD]
[/TR]
[TR]
[TD="align: center"]ZZZZ
[/TD]
[TD="align: center"]CCCC
[/TD]
[/TR]
[TR]
[TD="align: center"]John
[/TD]
[TD="align: center"]..Maths
[/TD]
[/TR]
[TR]
[TD="align: center"]Harry
[/TD]
[TD="align: center"].Science
[/TD]
[/TR]
[TR]
[TD="align: center"]James
[/TD]
[TD="align: center"]..English
[/TD]
[/TR]
[TR]
[TD="align: center"]Anna
[/TD]
[TD="align: center"]...History
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]C
[/TD]
[TD="align: center"]I
[/TD]
[/TR]
[TR]
[TD="align: center"]XXXX
[/TD]
[TD="align: center"]AAAA
[/TD]
[/TR]
[TR]
[TD="align: center"]YYYY
[/TD]
[TD="align: center"]BBBB
[/TD]
[/TR]
[TR]
[TD="align: center"]ZZZZ
[/TD]
[TD="align: center"]CCCC
[/TD]
[/TR]
[TR]
[TD="align: center"]John Harry James Anna
[/TD]
[TD="align: center"]..Maths .Science ..English ...History
[/TD]
[/TR]
</tbody>[/TABLE]
Result
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]C
[/TD]
[TD="align: center"]I
[/TD]
[/TR]
[TR]
[TD="align: center"]XXXX
[/TD]
[TD="align: center"]AAAA
[/TD]
[/TR]
[TR]
[TD="align: center"]YYYY
[/TD]
[TD="align: center"]BBBB
[/TD]
[/TR]
[TR]
[TD="align: center"]ZZZZ
[/TD]
[TD="align: center"]CCCC
[/TD]
[/TR]
[TR]
[TD="align: center"]John
[/TD]
[TD="align: center"]..Maths
[/TD]
[/TR]
[TR]
[TD="align: center"]Harry
[/TD]
[TD="align: center"].Science
[/TD]
[/TR]
[TR]
[TD="align: center"]James
[/TD]
[TD="align: center"]..English
[/TD]
[/TR]
[TR]
[TD="align: center"]Anna
[/TD]
[TD="align: center"]...History
[/TD]
[/TR]
</tbody>[/TABLE]