My data looks as so:

Data ColA ColB ColC ColD
A 123 Zebra Monkey
B 456 Dog Cat
C 123 Mouse Rabbit
A 789 Horse Cow
C 789 Cat Dog

I'm trying to put a formula into ColB of the table below that will look in
ColA and find a match in ColB of the data, and if ColA of the data is equal
"A", concatenate the values in ColC and ColD - as shown below.

Table
123 ZebraMonkey
456
789 HorseCow

Thank you in advance.