I have a list of data with multiple values being the same in column A with
different lists of data in columns B, C, and D. I need to consolidate the
data in column A to one record or row and have the data in columns B, C, and
D move to single row. Any suggestions?