i have one column that has three rows of info
name
street address, City, State Zipcode
phone number

how do i make it a column an input and a row for each name? like,
Name | Street Address | City | State | ZIPcode | Phone number

thanks in advanced



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/