Have a look in HELP index for TRANSPOSE

--
Don Guillett
SalesAid Software

"Gautam" wrote in message
...
i have a sheet which contains following information

Name Last name
Address Title
City Telephone
Zip e mail
Country
of about 100nds of addresses

What i want to do in here is to get this information on another sheet
stored
in columns i.e

Name Address City Zip Country Title Telephone e-mail