Hi excel family!
need your help.
this is the situation I face in Excel:
Cell A is a non-unique key field.
Cell B is the assigned value.
Cell A_______Cell B
AAA_________TMPL
AAA_________TMPS
AAA_________TMPO
BBB_________TMPS
CCC_________TMPS
CCC_________TMPO
DDD_________TMPL
DDD_________TMPS
DDD_________TMPO
DDD_________TMPX
EEE__________TMPL
EEE__________TMPS
This is what I want to achieve:
Cell A_______Cell B
AAA_________TMPL + TMPS + TMPO
BBB_________TMPS
CCC_________TMPS + TMPO
DDD_________TMPL + TMPS + TMPO
EEE__________TMPL + TMPS
I want to concatenate the list entries into one cell and separate them with a + or an & sign.
How can I achieve this?
Thx a lot in advance!
need your help.
this is the situation I face in Excel:
Cell A is a non-unique key field.
Cell B is the assigned value.
Cell A_______Cell B
AAA_________TMPL
AAA_________TMPS
AAA_________TMPO
BBB_________TMPS
CCC_________TMPS
CCC_________TMPO
DDD_________TMPL
DDD_________TMPS
DDD_________TMPO
DDD_________TMPX
EEE__________TMPL
EEE__________TMPS
This is what I want to achieve:
Cell A_______Cell B
AAA_________TMPL + TMPS + TMPO
BBB_________TMPS
CCC_________TMPS + TMPO
DDD_________TMPL + TMPS + TMPO
EEE__________TMPL + TMPS
I want to concatenate the list entries into one cell and separate them with a + or an & sign.
How can I achieve this?
Thx a lot in advance!