Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 32

Thread: Can I unpivot multiple non-contiguous rows to columns?

  1. #11
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Can I unpivot multiple non-contiguous rows to columns?

    is that what you want?

    example
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  2. #12
    New Member
    Join Date
    Aug 2016
    Posts
    14
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can I unpivot multiple non-contiguous rows to columns?

    Right now I am interested in the processors only, so either would work, but I think I could use the rest of the first example in the future.
    That is awesome.
    Last edited by Mark_E; Aug 7th, 2019 at 07:25 PM.

  3. #13
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Can I unpivot multiple non-contiguous rows to columns?

    so just filter by processors
    the second example it was a joke because I really don't know what you want to achieve
    Last edited by sandy666; Aug 7th, 2019 at 08:10 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  4. #14
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Can I unpivot multiple non-contiguous rows to columns?

    check the file from post#11
    Now it contain Filter table where you can define one or two or even all Tasks then Refresh green table
    if you want remove any Task from the Filter table just delete value or choose blank position from the top of the DataValidation List
    Each change requires refreshing the green table
    Last edited by sandy666; Aug 7th, 2019 at 08:46 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  5. #15
    Board Regular
    Join Date
    Apr 2014
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can I unpivot multiple non-contiguous rows to columns?

    @sandy666,

    Is your result file still available? I'm unable to open it in any of by browsers (chrome, IE, Opera) neither as an online version nor download it.

    I'm interested in seeing the results.

    I get this error in IE and Opera https://i.imgur.com/MKHsrL8.png

    And this in chrome https://i.imgur.com/khuk8W1.png
    Last edited by bobby_smith; Aug 7th, 2019 at 09:45 PM.

  6. #16
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Can I unpivot multiple non-contiguous rows to columns?

    Firefox, Opera:



    Excel Online doesn't support PowerQuery aka Get&Transform (yet!)
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  7. #17
    Board Regular
    Join Date
    Apr 2014
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can I unpivot multiple non-contiguous rows to columns?

    When I click open in desktop App nothing happens.
    Is it possible for you to share via google drive, drop box, or another alternative to onedrive?

  8. #18
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Can I unpivot multiple non-contiguous rows to columns?

    open blank excel workbook first and try again

    edit:
    after picture from post#16 you can see something like this:



    choose one

    of course Allow or Try Again
    Last edited by sandy666; Aug 7th, 2019 at 10:50 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  9. #19
    Board Regular
    Join Date
    Apr 2014
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can I unpivot multiple non-contiguous rows to columns?

    Tried that. Still did not work.
    I was able to open the original file from the poster without any difficulty.

  10. #20
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,805
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Can I unpivot multiple non-contiguous rows to columns?

    because OP used GoogleDrive
    I'm not using GD/DropBox because I have the entire archive on OneDrive

    Hour of kindness , try this

    after one hour it will expire!
    Last edited by sandy666; Aug 7th, 2019 at 10:59 PM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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