Make a unique list depending on the first column

I got a datafile in excel which has a ID in the first column (A) where the ID might look like this; abc1012, abc1013 etc. This is a list of several other excel list with different kind of information. The thing is that a ID might have information in column B and C where on a another row the same ID have information in column E and F. I would like to create one row of these where the information from two rows is combined into one. In the attached file below you can see first how the data looks like and second how I would like too have the data through a macro.