Dear Potential Helper,
I currently have a large database in the following format, where there are some cells that are empty:
[TABLE="width: 1066"]
<tbody>[TR]
[TD="class: xl63, width: 82"]Mr Patel[/TD]
[TD="class: xl63, width: 82"]Mr Smith[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Mrs Smith[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Mr Lewis[/TD]
[TD="class: xl63, width: 82"]Mrs Lewis[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Mrs Jones[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Ms Lewis[/TD]
[/TR]
</tbody>[/TABLE]
What I need to do is create a list of the outputs in the row, so for this row, it would read as:
Mr Patel, Mr Smith, Mrs Smith, Mr Lewis, Mrs Lewis, Mrs Jones, Ms Lewis
So far, I have tried to use the concatenate function, but have failed in making the desired list (which is in a presentable manner).
Many Thanks,
KO69
I currently have a large database in the following format, where there are some cells that are empty:
[TABLE="width: 1066"]
<tbody>[TR]
[TD="class: xl63, width: 82"]Mr Patel[/TD]
[TD="class: xl63, width: 82"]Mr Smith[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Mrs Smith[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Mr Lewis[/TD]
[TD="class: xl63, width: 82"]Mrs Lewis[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Mrs Jones[/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 82"]Ms Lewis[/TD]
[/TR]
</tbody>[/TABLE]
What I need to do is create a list of the outputs in the row, so for this row, it would read as:
Mr Patel, Mr Smith, Mrs Smith, Mr Lewis, Mrs Lewis, Mrs Jones, Ms Lewis
So far, I have tried to use the concatenate function, but have failed in making the desired list (which is in a presentable manner).
Many Thanks,
KO69
Last edited: