combine multiple cells but with differing amounts of data in them

[tonywatsonhelp]

Hi Everyone,
I've got a bit of a problem not sure how to fix,

I need to combine the data from cells D,E,F,G & H into cell C
now this would be easy but I want a comer space ", " between each piece of data, again, would be easy but some row only have one cell with data others have all 5, so if I use the =D1&", "&E1&so on formula in get "Dave,,,,," for example
is there a way to do this so if the cells are empty I don't get lots of comers next to each other?

thanks

Tony

 

[konew1]

I only did it for 3 columns, but you can extend.

Excel Workbook
	A	B	C	D	E	F
1	Joe	Me	Hori	*	*	Joe, Me, Hori
2	Joe	*	Hori	*	*	Joe, Hori
3	Joe	Me	*	*	*	Joe, Me
Sheet4

 

[tonywatsonhelp]

Excellent, thank you, I was trying to do an if but mine was getting way out of hand this is a lot better, thank you

 

[konew1]

You're welcome. You may need to modify if the first column could be empty, but data in other columns.
My formula will return ", me" if Joe isn't there