Formula help needed
 

Hi:

I have a spreadsheet that needs to capture some basic information
(name, street, city, etc.) from a form that individuals are filling
out.

The form is in Excel and there is a box that has Name, Company, Street,
City, State, Zip.
Hopefully the individual will put each item on a separate line.

How do I get the information from the form onto the spreadsheet? There
is a column for each field; however, the sheet is already divided into
companies. It would be nice to have a formula put each person under
the correct company.

Any help would be appreciated.
Thanks!
cheetah