Results 1 to 5 of 5

Thread: Unpivot Columns in Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-15-2017, 02:29 AM #2
    jomili
    jomili is offline
    Junior Member
    Join Date
    Jul 2011
    Posts
    19
    Rep Power
    0
    Tried to give it a whirl but no go. I've attached my pivot so we can understand each other. For "Select the data range(including column header)" I take that to mean D1:I64. But when it says "Select the unpivot data range(only column header)." I have no idea what it's asking for. My best guess is to select only A1:I1, but that doesn't work.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. UNPIVOT crosstab sheet using SQL and get count of items.
    By Junoon in forum Excel Help
    Replies: 0
    Last Post: 03-27-2016, 02:26 AM
  2. Excel VBA to copy and paste columns
    By gripper in forum Excel Help
    Replies: 4
    Last Post: 04-15-2015, 06:03 PM
  3. how-to-transfer-data-from-excel-into-outlook-in-controled-columns
    By peter renton in forum Excel Help
    Replies: 1
    Last Post: 01-19-2014, 04:45 PM
  4. Macro To Insert Columns In Excel
    By jac3130 in forum Excel Help
    Replies: 2
    Last Post: 05-17-2013, 07:49 AM
  5. Validating 2 Columns using excel VBA
    By freakszzy in forum Excel Help
    Replies: 2
    Last Post: 07-26-2012, 12:46 PM

Tags for this Thread

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
  •  

Forum Rules