Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Array + Transpose + Table

  1. #11
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,929
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Array + Transpose + Table

    another alternative is to use Power Query. Here is the Mcode

    Code:
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value")
    in
        #"Unpivoted Columns"
    v A B
    1 Attribute Value
    2 Project A
    3 Owner Jack
    4 Status On Track
    5 Risk None
    6 Team None
    7 Project B
    8 Owner Mary
    9 Status RIsk
    10 Risk Short on funding
    11 Team Joe, Mary, Mira
    12 Project C
    13 Owner Vick
    14 Status Need Help
    15 Risk Need more resources
    16 Team Kayle, Mike
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


  2. #12
    New Member
    Join Date
    Mar 2014
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Array + Transpose + Table

    Quote Originally Posted by RasGhul View Post
    Here's a dropbox link to a mockup table version with a guide to how it is made for reference for your sheet.

    Note that you should make a copy of your original file and see if you like the end result first before applying to your real file.


    https://www.dropbox.com/s/6zm758ke1a...sion.xlsx?dl=0
    Thank you. It worked!

  3. #13
    New Member
    Join Date
    Mar 2014
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Array + Transpose + Table

    Thanks. You made it much easier and it worked.

  4. #14
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,929
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Array + Transpose + Table

    Thanks. You made it much easier and it worked.
    Who is this meant for? Did you try the Power Query Solution?
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


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
  •