Hi Guys,
Really looking forward to your help with this one.
I needs to combine cell data and have a comma spacing between them. however I don't want empty cells to merge.
For example,
<tbody>
</tbody>
I need it to read:
Apple,Tomato,Banana,Apple,Apple,Tomato ( notice how the gap was ignore for row 6 and 8.
I know that the concatenate function can help but I have having trouble with the gap.
I am using the following:
=concatenate(A1,",",A2,","A3) and so on. but the blank cell are affecting the end result.
Thanks in advance for your help,
Raziel
Really looking forward to your help with this one.
I needs to combine cell data and have a comma spacing between them. however I don't want empty cells to merge.
For example,
1. | Apple | ||||||
2. | Tomato | ||||||
3. | Banana | ||||||
4. | Apple | ||||||
5. | Apple | ||||||
6. | |||||||
7. | Tomato | ||||||
8. |
<tbody>
</tbody>
I need it to read:
Apple,Tomato,Banana,Apple,Apple,Tomato ( notice how the gap was ignore for row 6 and 8.
I know that the concatenate function can help but I have having trouble with the gap.
I am using the following:
=concatenate(A1,",",A2,","A3) and so on. but the blank cell are affecting the end result.
Thanks in advance for your help,
Raziel