Any formula for making multiple column be single column separatef by pipe?

Hallo sir, Any Idea for making multiple column be single column separatef by pipe?
I wanna make like this picture
2014-12-15_204618.png

But I think, if the problem can not be solved, can make the alternative like this?
2014-12-15_204653.png

here is the sample sheet example 4.xlsx
Many Thanks

if I use =CONCATENATE(C3;" | ";D3;" | ";E3;" | ";F3;" | ";G3;" | ";H3)
it will be
S | M | L | XL | 2XL | 3XL
S | M | | | |
XL | 2XL | 3XL | | |
M | L | 2XL | 3XL | |

What about if the column is blank and it is not use the pipe?

Solved! found from http://datadrunk.com/wp-content/uplo...catUnique.xlsm

Without VBA, try

=SUBSTITUTE(TRIM(C3&" "&D3&" "&E3&" "&F3&" "&G3&" "&H3)," "," | ")