how to transpose the column data to rows heading.i have Person name, Company, Address1, Address2 City, State, Zip Code, Country, Phone, Fax, Email, Website,
Ex: Rebecca J. Blue Interior Planning Consultants, Inc. 300 S Jefferson Ave Springfield MO 65806-2219 USA (417) 864-5500 (417) 864-8475 rblue @ intplan.com http://www.intplan.com
in some rows data will miss so how to refix the data to match the correct heading
ex:
Mrs. Migena Guage Saint Louis MO USA migenaguage @ gmail.com
but no hint in the datas