Grouping multiple rows into one row and create columns

I have a excel spreadsheet that contains like data in column A. In the E column it contains numbers 1-4. I need to be able to keep the number in Column A if the number in E column is different for that #. I have attached a copy of the spreadsheet showing what it looks like now and another copy of the spreadsheet showing what I need the data to look like.