PrimeTimeAction
New Member
- Joined
- Aug 1, 2018
- Messages
- 9
I want to make macro to combine a group of data (separated by blank rows) from multiple cells in a column into one cell with carriage return (alt+enter) between each cell value. Can somebody help me with this.
see below:
[TABLE="width: 281"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 281"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
see below:

[TABLE="width: 281"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 281"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]