Results 1 to 5 of 5

Data Mismatch

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    41

    Data Mismatch

    I have a spreadsheet that I am trying to turn the data from a top down look to a linear look. The data goes top to bottom and I am trying to get it to go left to right.

    Here is an example:
    Right now the data looks like this.

    Prt_Nbr Schd_Dt Schd_Qty
    12345678984 7/15/2013 0:00 0
    12345678984 7/22/2013 0:00 60
    12345678984 7/29/2013 0:00 60
    12345678984 8/5/2013 0:00 60


    I would like to see it like this

    07/15/2013 07/22/2013 07/29/2013 08/5/2013
    12345678984 0 60 60 60
    12354894987 60 20 60 60


    Ill attach some file examples too.

    Can this be done?
    Attached Files Attached Files
    Last edited by agengler11; 06-25-2013 at 11:28 AM. Reason: Text formatting off

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