help. need a formula

[samway301]

i have a spreadsheet with many rows that i need sorted. it looks something like what's below... (there are ~2500 companies in total)

A

Company A

Name

Address

City, State, Zip

Phone

Fax

Email

Fluff

Fluff

Fluff

Company B

name

address

city, state zip

phone

fax

email

fluff

fluff

fluff

fluff

fluff

fluff

Company C

<tbody>
</tbody>

is there a formula that'll copy the data starting with the green text for company name, and put name, address, phone, fax, email onto another sheet? the 'fluff' varies from 5 rows to 20. it's not consistent.

i'm looking for output similar to whats below: (keeping the green text is not necessary)

A B C D E F

Company A	Name	Address (street, city, state, zip	Phone	Fax	Email
Company B	Name	Address (street, city, state, zip	Phone	Fax	Email
Company C	Name	Address (street, city, state, zip	Phone	Fax	Email

<tbody>
</tbody>

Thank you in advance.

 

[VBA Geek]

is the 'fluff' actually fluff in the file or does it mean it can be any text?

 

[samway301]

it can be any text. it's text that i don't need copied into the new row.