M
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.
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.