Results 1 to 2 of 2

Need Help to Transpose multiple sets of data into rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need Help to Transpose multiple sets of data into rows

    So I'm new here and I apologize if this has been extensiveley covered, but I am on a deadline.

    I have a spreadsheet with store locations that looks like this:

    Allen, TX
    OUTLET-Allen Premium Outlets
    Store #: 780
    820 W Stacy Rd
    Suite 410
    Allen, TX* 75013
    972-678-2612
    Map

    Allen, TX
    Watters Creek at Montgomery Farm
    Store #: 689
    827 Market Street
    Allen, TX* 75013
    214-383-3009
    Map

    Amarillo, TX
    The Forum at Soncy
    Store #: 430
    3350 South Soncy Road
    Suite 116
    Amarillo, TX* 79124
    806-352-4473
    Map (Formatted as a link)


    I need each store to be transposed into a single row. So Name, Store #, Address, City, State, Zip, and Phone number all accross one row.

    What is the easiest way to do this?
    Last edited by sacklunch; 10-17-2011 at 04:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1