I am trying to consolidate multiple records into a single row as follows:

For each unique entry in column A, I want to consolidate all the various inputs in column B into a single cell separated by commas. I would then repeat the process for column C and finally column D.

The image below illustrates what I am attempting to do.

Consolidate.jpg