dynamic search
 

I am exporting data that looks like this:
Subdivision Lot Date 1 Memo1 Line# Description
93101100000 0001 SPEC 10 Buyer
93101100000 0001 8/15/05 20 Color Selects
93101100000 0015 MODEL 40 Buyer
93101100000 0015 8/01/05 70 Color Selects

I need to move all this data to make it look like this:
Buyer Lot Color Selects
SPEC 0001 8/15/05
MODEL 0015 8/01/05

There are currently 13 items repeating over and over and may or may not have
data in them. I need help in the formula to convert this table. Any help is
appreciated.