Forum Discussion

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

venug20

 

Is this your expected result

 

Company City
LifeLock Tempe
LifeLock Tempe
ChosenList.com Scottsdale
ChosenList.com Scottsdale
Facebook Palo Alto
Facebook Palo Alto
Facebook Palo Alto
Geni West Hollywood
Geni West Hollywood
Slacker San Diego
Slacker San Diego
Technorati San Francisco
Technorati San Francisco
Mahalo Santa Monica
Mahalo Santa Monica
Veoh San Diego
Veoh San Diego
Jingle Networks Menlo Park
Jingle Networks Menlo Park
Prosper San Francisco
Prosper San Francisco
Jajah Mountain View
Jajah Mountain View
Ustream Mountain View
Ustream Mountain View
Aggregate Knowledge San Mateo
Aggregate Knowledge San Mateo
Sphere San Francisco
Sphere San Francisco
MeeVee Burlingame
MeeVee Burlingame
  • venug20's avatar
    venug20
    Resolver I
    8 years ago

    Zubair_Muhammad

     

    Yes, Exactly i expected same like which you have filled data...

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      venug20

       

      I used this

       

      let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Company", type text}, {"City", type text}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1),
    #"Trimmed Text" = Table.TransformColumns(#"Added Index",{{"Company", Text.Trim, type text}, {"City", Text.Trim, type text}}),
    #"Sorted Rows" = Table.Sort(#"Trimmed Text",{{"Company", Order.Ascending}, {"City", Order.Descending}}),
    #"Filled Down" = Table.FillDown(#"Sorted Rows",{"City"}),
    #"Sorted Rows1" = Table.Sort(#"Filled Down",{{"Index", Order.Ascending}}),
    #"Removed Columns" = Table.RemoveColumns(#"Sorted Rows1",{"Index"})
in
    #"Removed Columns"