I have a spreadsheet that is created by a program I use at work. I run this
report weekly and there are hundreds of loads each week. The spreadsheet has
the info I need but not in the right format. I need to know if there is a
way to pull this info into another spreadsheet in the format I am looking for
without a bunch of copying and pasteing. He is an example of what the report
looks like

Load# Destination Charge Desc. Charges
Total
12345 Columbus, OH Fuel $100
$300
12345 Columbus, OH Stop $50
$300
12345 Columbus, OH Linehaul $150
$300

It gives multiple rows of info to display the charges within the load. I
need to it to be 1 column with the charges listed across seperat columns
instead of seperate rows. This is what I need it to look like.

Load# Destination Linehual Stop Fuel
Total
12345 Columbus, OH $150 $50 $100
$300

Thanks for your help.