Hi - I have wrote the formula to Combine cells horizontally in one cell in list format. I have attached the workbook. The result is in column D. Thought to share if it is useful for someone