Help: How to transpose data (Complicated)

[tearheaven]

Dear All, Please help...

I have a list of contact copy from internet, but all information is in one column A1 only. I need to seperate out into A1, B1, C1, D1, E1. Is there anyway to speed up??

Example,

A1
A company
Address 1
Address 2
State, Country
Telephone
B company
Address 1
Address 2
State, Country
Telephone
C company
Address 1
Address 2
State, Country
Telephone

Now I have to copy and paste special by transpose every 5 column...
A1 B1 C1 D1 E1
A Company Address 1 Address 2 State, Country Telephone
B Company Address 1 Address 2 State, Country Telephone
C Company Address 1 Address 2 State, Country Telephone

Please help....

[fredlo2010]

hi,

each company has 5 values always? no blank cells in the middle?

Thanks

[tearheaven]

hi,

each company has 5 values always? no blank cells in the middle?

Thanks

Yup, always 5 value and no spacing in between.. any idea?

[fredlo2010]

Hi,

See if this helps. Please modify to meet your specific needs

Please Login or Register  to view this content.

Thanks