Excel-How to Convert Vertical Date to Horizontal (attachmet Excel)

[Prajnan ks]

How to Convert two vertical Data by keeping one Vertical and other Horizontally??

 

[AlanSidman]

Pivot your data in Power Query. Here is the Mcode for those steps. File attached for your review.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"PO No"}, {{"Data", each _, type table [PO No=nullable number, Desc=nullable text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data],"Index",1,1)),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Desc", "Index"}, {"Custom.Desc", "Custom.Index"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Data"}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Removed Columns", {{"Custom.Index", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Removed Columns", {{"Custom.Index", type text}}, "en-US")[Custom.Index]), "Custom.Index", "Custom.Desc")
in
    #"Pivoted Column"

 

[Prajnan ks]

Pivot your data in Power Query. Here is the Mcode for those steps. File attached for your review.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"PO No"}, {{"Data", each _, type table [PO No=nullable number, Desc=nullable text]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Data],"Index",1,1)),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Desc", "Index"}, {"Custom.Desc", "Custom.Index"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Data"}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Removed Columns", {{"Custom.Index", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Removed Columns", {{"Custom.Index", type text}}, "en-US")[Custom.Index]), "Custom.Index", "Custom.Desc")
in
    #"Pivoted Column"

OHH Waah Thank U So Much Sir, Hurry

 

[Peter Bartholomew]

365 also has solutions. For example, calculating distinct PO nos. 'DistinctPO's using the first formula, will allow the rows of the output table to be calculated one-by-one using the second formula.

= UNIQUE(PONo)

=TRANSPOSE(FILTER(Desc, PONo=@DistinctPO#))

 

[Prajnan ks]

365 also has solutions. For example, calculating distinct PO nos. 'DistinctPO's using the first formula, will allow the rows of the output table to be calculated one-by-one using the second formula.

= UNIQUE(PONo)

=TRANSPOSE(FILTER(Desc, PONo=@DistinctPO#))

Hi Can u Upload Excle File Please

 

[Peter Bartholomew]

Let me know it you have trouble with the formulae.

 

[Prajnan ks]

Let me know it you have trouble with the formulae.

Thank U sir, this is also serve purpose, but i dont know how to use those Formulas can u help me??