Excel expert needed. Need data in a specific format.

I have a large data file and I've attached a small sample in tab delimited. I'll try to explain the best I can. I have a MODEL field and a lot of those are identical. its in Column 1 I have a category field in Column 5 What I'd like to do is have excel look look at MODEL and write that whole ROW to a new sheet. But then it looks for that same MODEL and if found it takes Column 5 and adds it to the last column of the new sheet. And it keeps adding that column 5 data to the new sheet at the end until it can't find anymore exact Model. Then it goes to the next line of data. So this is an example of sheet 1 (my original data) ACU-77099Y 255.6 Bumper Description goes here 2014>GM>TL>BASE ACU-77099Y 255.6 Bumper Description goes here 2014>ACURA>TSX>BASE Notice the first column data in each line are identical (ACU-77099Y) so sheet two would simply be this ACU-77099Y 255.6 Bumper Description goes here 2014>GM>TL>BASE 2014>ACURA>TSX>BASE All on sheet two in one single row. Each thing having its own cell So it just created the one Model and added 2014>ACURA>TSX>BASE to the end. Then look for more of the same Model and keep adding to the end if it finds more. If it can't find more it goes to the next row of data and so on. I have a large file I only need done one time. I don't even really need the excel script or anything. This is a one time deal. But giving me the script may be good so I can test it myself.