XL 2003

I have about 150 groups that I would like to put into rows in Excel...
1 row/group.

They are like this:

WOODSTOCK & DISTRICT BIG BROTHERS ASSOC. INC.
378 Hunter St
Woodstock, ON N4S 4G2
(519) 539-7469

www.bigbrotherswoodstock.ca

BIG BROTHERS BIG SISTERS OF YORK
PO Box 126, 145 Main St. S
Newmarket, ON L3Y 3Y9
(905) 895-0289

www.bbbsy.ca

There are tabs at the end of each and every line.
(or if I paste the data unformatted, there are returns at the end of
each and every line.)

I would like 1 row and 6 columns per group. I know I can copy and
paste special transpose each group but I have lots of them!
Is there an easier way to do this?

....Lisa