CONCATENATE cells if other cells are the same

[Mally]

Hi

If cells A1:A3 are the same then I want to CONCATENATE cells B1:B3 into
cells E1:E3 and C1:C3 into F1:F3
e.g.
A B C D E F
1 1 B A B A
2 2 S E S D E Q
3 2 D Q
4 5 L D L D
5 8 S T S A T Z
6 8 A Z

I need to copy this formula down my worksheet.

Thanks in advance for any help.

 

[Mally]

This should read

If cells A1:A3 are the same then I want to CONCATENATE cells B1:B3 into
cells D13 and C1:C3 into E1:E3
e.g.
A B C D E
1 1 B A B A
2 2 S E S D E Q
3 2 D Q
4 5 L D L D
5 8 S T S A T Z
6 8 A Z

I need to copy this formula down my worksheet.

Thanks in advance for any help.

 

[Ron Coderre]

If Row_1 can contain headings and your data can start in Row_2...
Try this:
D2: =IF($A2<>$A1,B2,"")&IF($A2=$A3,B3,"")&IF($A2=$A4,B4,"")

Copy that formula across and down through E7.

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)

 

[Mally]

Thanks Ron. Thats what i wanted with the exception if some cells contain the
same words then these are repeated. Is it possible for just one of unique
values to be displayed. Currently my results look like this

YesYesYesYesTrafficTraffic

I want it to look like this

Yes Traffic

with a space in between

etc.

Thank you again