Results 1 to 4 of 4

Thread: Transpose from columns to rows. Pivot/Unpivot seems to not apply in this situation

  1. #1
    Seeker nangys's Avatar
    Join Date
    Jan 2017
    Posts
    11
    Articles
    0
    Excel Version
    2010

    Transpose from columns to rows. Pivot/Unpivot seems to not apply in this situation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have tried to use pivot/unpivot functions and the tranpose function but they do not seem to work in this situation.

    Click image for larger version. 

Name:	transpose.png 
Views:	19 
Size:	7.1 KB 
ID:	8886

    Thank you in advance.

    Fernando
    Attached Files Attached Files

  2. #2
    Seeker ExcelStarter's Avatar
    Join Date
    Jan 2018
    Posts
    19
    Articles
    0
    Excel Version
    2016
    I hope it helps.
    Attached Files Attached Files
    Last edited by ExcelStarter; 2019-02-14 at 09:38 AM.

  3. #3
    Acolyte Bill Szysz's Avatar
    Join Date
    Apr 2016
    Location
    Poznań, Poland Dublin, Ireland
    Posts
    99
    Articles
    0
    Excel Version
    Excel 365
    Code:
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Grouped Rows" = Table.Group(Source, {"Region"}, {{"All", each Table.AddIndexColumn(_,"Index",1,1), type table }}),
        #"Expanded All" = Table.ExpandTableColumn(#"Grouped Rows", "All", {"Zip", "Index"}, {"Zip", "Index"}),
        #"Added Prefix" = Table.TransformColumns(#"Expanded All", {{"Index", each "ZIP" & Text.From(_), type text}}),
        #"Pivoted Column" = Table.Pivot(#"Added Prefix", List.Distinct(#"Added Prefix"[Index]), "Index", "Zip")
    in
        #"Pivoted Column"

  4. #4
    Seeker nangys's Avatar
    Join Date
    Jan 2017
    Posts
    11
    Articles
    0
    Excel Version
    2010
    Much appreciated Thank you!

Tags for this Thread

Posting Permissions

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