在PowerQuery Editor中创建新表

 Table.FromRecords(

    
     {
    
         [ID = "A", Number = 12],
    
         [ID = "A", Number = 5],
    
         [ID = "A", Number = 6],
    
         [ID = "A", Number = 8],
    
         [ID = "B", Number = 14],
    
         [ID = "B", Number = 9],
    
         [ID = "B", Number = 7],
    
         [ID = "B", Number = 7],
    
         [ID = "C", Number = 5],
    
         [ID = "C", Number = 16],
    
         [ID = "C", Number = 18]
    
     },
    
     type table [ID = nullable text, Number = nullable number]
    
     )