Hi guys,
I have a table reading like:
Col A Col B
1 abc
1 def
2 ryu
3 deff
3 dell
4 nodata
5 exp
5 part
5 file
-----------------------------------
The result I am looking for is like this
Col A Col B
1 abcdef
3 deffdell
5 exppartfile
Basically I need to have a concatenation of the the column B for those values that are to be found in the column A more than once. I am looking for a solution based on excel with no VBA. Thanks a lot guys.
I have a table reading like:
Col A Col B
1 abc
1 def
2 ryu
3 deff
3 dell
4 nodata
5 exp
5 part
5 file
-----------------------------------
The result I am looking for is like this
Col A Col B
1 abcdef
3 deffdell
5 exppartfile
Basically I need to have a concatenation of the the column B for those values that are to be found in the column A more than once. I am looking for a solution based on excel with no VBA. Thanks a lot guys.