Dear Potential Helper,
I currently have a large database in the following format, where there are some cells that are empty:
<tbody>
</tbody>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:
Mr Patel | Mr Smith | Mrs Smith | Mr Lewis | Mrs Lewis | Mrs Jones | Ms Lewis |
<tbody>
</tbody>
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: