Hello,

I have a simple spreadsheet with 2000 vendors names in the first column A
and address ect data in columns B - K. How can I get the data to reformat to
have column A list the vendor name in Cell A1 and all the other info be
presnet in B1-10 and then continue for all 2000 vendor names. I've torn my
hair out over this....I'm sure it's simple but I haven't had any luck at
all... Any thoughts appreciated.

Thank You,

Extreem