Hi

I need to analyze some shipment data that is not currently in a format suitable for analysis.

My shipment data consists of a shipment no., basic freight charge, fuel surcharge, customs fee etc. The problem is that each charge is specified on a separate line. This means that data about each shipment is covering several lines in my spreadsheet. To sum up column A contains shipment no. Column B: Charge type. Column C: Charge cost.

I would like the data to be structured so each shipment covers only one row, and each individual charge type has its own column.

Any ideas on how to achieve this?