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,B 4,"")

Copy that formula across and down through E7.

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)


"Mally" wrote in message
...
This should read

If cells A1:A3 are the same then I want to CONCATENATE cells B1:B3 into
cells D1:D3 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.


"Mally" wrote:

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.