Grouping by column value / Transposing Data by column value

I'm trying to figure out how to group or transpose data by column value... I have about 15,000 rows of data that need to be organized so I can't do this manually.

The data is output from software that I use and organized by "ID" (which is col1) then each parameter attached to that ID is listed one after the other until all parameters for that ID are listed, then it moves on to the next ID and lists all of the parameters for the next ID.

I need to group all parameters from each ID into ONE row instead of having them in columns. Example below...

e.g.
Input

col1 col2
1 1.1
1 10
1 11
2 98
2 yes
2 orange
3 21
3 5678
3 blue

Desired Result

col1 col2 col3 col4
1 1.1 10 11
2 98 yes orange
3 21 5678 blue


Any help is greatly appreciated...

Why not use a pivot table?

Also, post sample data.

I'm not very experienced with Pivot Tables. Here is a small sample of what the data looks like when I receive it and at the bottom is an example of what I want the result to look like.

Each "ID" is the exact same group of data so they need to remain together. The data is always consistent. The are 9 rows that make up each "ID" or group of data that needs to remain together.
The 2nd-4th columns need to remain in order from left to right then the 5th and 6th columns need to be transposed from a column to a row. The 5th row repeats and really only needs to be transposed once as a header for the 6th row.

I hope this makes sense?
Hopefully the attachment with clarify.

Thank you for your help!

Fuel-Burn-Test1.xlsx

This is athe PERFECT time for you to learn about pivot tables. They will change your life.
Does it have to be in the exact order you placed in the horizontal table? If so you might have to play with manually sorting the column headers once you have constructed the pivot table.

Quick overview of what I did in about 15 seconds:
I highlighted B1:F55 then went to INSTER tab, then checked Pivot table. Then hit OK. From there I put ID in the ROWS (which aggregates them into one row each like you wanted), Paramter Name in the columns and PEAK1 in Values. I attached the workbook for you to view.

It is INCREDIBLY easy once you spend the 5-15 minutes learning what things do.

http://chandoo.org/wp/excel-pivot-tables/
http://fiveminutelessons.com/learn-m...ot-table-excel
http://www.youtube.com/results?searc...be.6pjeeyTB5g4


To manually sort the columns you will want to follow the instrucitons here:
http://office.microsoft.com/en-us/ex...010175904.aspx

Fuel-Burn-Test1.xlsx

You're awesome! Thanks for the help! I've messed with Pivot Tables a "little" bit in the past but this brought it to a new light and now that I understand how they work I'll use them often. Problem solved!

Thank you again.

Sweet, can you mark the thread solved?