search for a list of cars by manufacturer, put data in separate column according to manufacturer

[spidertech]

I have a large file with a single row of different car manufacturers (acura, bmw, honda, cadillac, dodge, toyota, nissan, subaru, huyndai, jaguar) under each manufacture is a list of items/features that belongs to that manufacturer, such as speakers, name of sound systems, navigation, CD/DVD player...etc

I'd like to be able to read each manufacturer and all the features that listed under them and display them in columns. For instance:
Acura bmw honda (these are the column headers)
bose speakers jbl speakers tandem navigation systems
electric windows 5 speed transm turbo option
awd cd/dvd player heated seats
etc.... etc.... etc....
etc.... etc.... etc....
etc.... etc.... etc....
etc.... etc.... etc....
the items/features can be very long for each manufacturer, so the script needs to read thru all the items/features listed for that manufacturer and continues to read until it reaches a new manufacturer: honda, read all the items listed underneath it and repeat the reading process like it did in the first column, until it reaches the next manufacturer name and create a new column.....until eof

If it's not clear, please let me know and I'll try a different way to explain so that you understand.

Thanks,

 

[My Aswer Is This]

You said:
I have a large file with a single row of different car manufacturers
Would this be Row(1)
And if in Range("A1") we have "Ford"
all the features for Ford will will be in column(A)

So how is it we find another Manufacture name in column A?
You said:
so the script needs to read thru all the items/features listed for that manufacturer and continues to read until it reaches a new manufacturer:

So can you clear this up for me?