Populate values while excluding one

Not sure what to name the title so I apologize if it is confusing.

Here is what I am trying to do and I'd like to know if there is a formula for it. I have values in column A which I need transposed and populated into column C, in one cell, separated by a space but excluding the value from the same row.

As you'll notice in the diagram below, Cell C1 contains all values from column A but excludes the the value in the corresponding row and so on down the list.

A		B C D E
B		A C D E
C		A B D E
D		A B C E
E		A B C D

I am not very good with Excel and I would appreciate any assistance with solving this.

Thanks in advance!

try this UDF

Please Login or Register  to view this content.

@nilem

That worked great! Thank you!