Results 1 to 6 of 6

Tricky Import Situation

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    Atlanta
    MS-Off Ver
    Office 2010
    Posts
    8

    Tricky Import Situation

    I have some data that I'd like to put in a spreadsheet, and can't figure out the trick to doing this. Here is how the table in SQL Server looks, but of course I could export this to a flat file, or a smiple spreadsheet

    name year month count
    ----- ---- ----- -----
    aaa 10 6 555
    bbb 10 5 22
    aaa 11 2 345
    ccc 10 1 44


    There are actually about 350+ rows in this table. Roughly 35 unique names, and the dates will span from January of 2010 to March of 2012.

    Here is how I'm hoping to get the spreadsheet to look. Of course, I would manually edit the headers once the data is in place:



    ------------------------------- 2010 -------------------------------- ---------2011 (etc)
    Name Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar (etc)
    aaa 555 345
    bbb 22
    ccc 44


    There will be one unique entry for each of the buckets.

    Thanks for any help with this!
    Last edited by johnmsch; 03-13-2012 at 06:33 PM. Reason: Even using Courier New font, I can't get the rows to line up correctly!!!

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