How to gathering data into column?

Hi saranp780 ,

At first, you need to import it and set two column names. Open query editor.

Then add an index column.

Pivot column Type. Do not aggregate value.

Then you can get the following table.

Select column OS -> hold down shift -> left-click on column RAM. Go to the tab Transform -> select Fill -> press Up.
Filter out null values from column Serial. Remove index column. Click Close & Apply.

Here is the all codes in the Advanced Editor.

let
   Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk4tykzMUdJRMjY1MDAwNDYzNVCK1YlW8g8GioVn5qXklxtCRJwDQoFCnnklqTkKzvlFqQqZphDxnPzkbKCMkZ6Ju0cVWCjI0RcoYOLuBOZhWGFIcxuMMG1QCCjKx2GLOX5bLEC2xAIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"(blank)" = _t, #"(blank).1" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"(blank)", type text}, {"(blank).1", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"(blank)", "Type"}, {"(blank).1", "value"}}),
    #"Added Index" = Table.AddIndexColumn(#"Renamed Columns", "Index", 0, 1),
    #"Pivoted Column" = Table.Pivot(#"Added Index", List.Distinct(#"Added Index"[Type]), "Type", "value"),
    #"Filled Up" = Table.FillUp(#"Pivoted Column",{"OS", "CPU", "Clock", "RAM"}),
    #"Filtered Rows" = Table.SelectRows(#"Filled Up", each ([Serial] <> null)),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Index"})
in
    #"Removed Columns"

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.