Skip the double characters (Formula) ?

[hpbaxxter]

Hello,
I need a formula and nor Macro to skip the double characters and show the characters only once as in this table ,and thanks

 

[bosco_yip]

Formula way with helper,

1] D2, copy down :

=LEFT(A2,FIND(" ",SUBSTITUTE(A2,CHAR(160)," ")&" ")-1)

2] E2, copy down :

=TRIM(SUBSTITUTE(SUBSTITUTE(A2,D2,""),CHAR(160),""))

3] B2, copy down :

=IFERROR(IFERROR(INDEX(D$2:D$10,MATCH(0,INDEX(COUNTIF(B$1:B1,D$2:D$10),0),0)),INDEX(E$2:E$10,MATCH(0,INDEX(COUNTIF(B$1:B1,E$2:E$10),0),0))),"")

Regards
Bosco

 

[hpbaxxter]

Formula way with helper,

1] D2, copy down :

=LEFT(A2,FIND(" ",SUBSTITUTE(A2,CHAR(160)," ")&" ")-1)

2] E2, copy down :

=TRIM(SUBSTITUTE(SUBSTITUTE(A2,D2,""),CHAR(160),""))

3] B2, copy down :

=IFERROR(IFERROR(INDEX(D$2:D$10,MATCH(0,INDEX(COUNTIF(B$1:B1,D$2:D$10),0),0)),INDEX(E$2:E$10,MATCH(0,INDEX(COUNTIF(B$1:B1,E$2:E$10),0),0))),"")

Regards
Bosco

thanks for the answer, but I guess you didn't understand me, I want very name appear just once and doesn't matter how much it writes, example :
I have
a a
a b
b c
c
a e
and I want to get this a, b, c, e

 

[bosco_yip]

thanks for the answer, but I guess you didn't understand me, I want very name appear just once and doesn't matter how much it writes, example :
I have
a a
a b
b c
c
a e
and I want to get this a, b, c, e

The Post no.2, [3] formula, replace with this revised :

In B2, array formula (entered with pressing SHIFT+CTRL+ENTER 3 keys together) copy down :

=INDIRECT(TEXT(MIN(IF(COUNTIF(B$1:B1,D$2:E$10&""),4^8,ROW($2:$10)/1%+{4,5})),"R0C00"),)&""

Regards
Bosco

 

[hpbaxxter]

The Post no.2, [3] formula, replace with this revised :

In B2, array formula (entered with pressing SHIFT+CTRL+ENTER 3 keys together) copy down :

=INDIRECT(TEXT(MIN(IF(COUNTIF(B$1:B1,D$2:E$10&""),4^8,ROW($2:$10)/1%+{4,5})),"R0C00"),)&""

Regards
Bosco

Thank you