Hi, I've been trying to come up with a formula that combines multiple list while removing spaces in between and keeping duplicates but to no success. Is there any formula to do this?
E.g.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]List1
[/TD]
[TD]List2
[/TD]
[TD]List3
[/TD]
[TD]Combined
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]Apple
[/TD]
[TD][/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]Paper
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Paper
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Food
[/TD]
[/TR]
[TR]
[TD]Food
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Apple
[/TD]
[TD]Orange
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Tomato
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Orange
[/TD]
[TD][/TD]
[TD]Tomato
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks!
E.g.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]List1
[/TD]
[TD]List2
[/TD]
[TD]List3
[/TD]
[TD]Combined
[/TD]
[/TR]
[TR]
[TD]Apple
[/TD]
[TD]Apple
[/TD]
[TD][/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD]Paper
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Paper
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Food
[/TD]
[/TR]
[TR]
[TD]Food
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Apple
[/TD]
[TD]Orange
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Tomato
[/TD]
[TD]Apple
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Orange
[/TD]
[TD][/TD]
[TD]Tomato
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks!