Results 1 to 4 of 4

Make Horizontal Data Arroay into Vertical String

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    14

    Make Horizontal Data Arroay into Vertical String

    Hi All,

    Please see attached file for my issue. As you can see I have a horizontal array of data from F3:X222. I need to take the data and make it sequential in a continuous format in Column F. So currently I have to copy the data from G3:G222 and Paste in cell F223 and so on with each half hour. Does anyone know an easier way to do this. This is one of many days of data27-Feb.xlsx.

    Thanks,

    Sage
    Last edited by mshirschy; 03-29-2013 at 09:44 AM.

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