In Excel, load the Table/Query into Power Query. Run the Mcode below to transform the data.
Code:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Transposed Table" = Table.Transpose(Source),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Cell#", Int64.Type}, {"Part#", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "System ID", each "A1"),
#"Reordered Columns" = Table.ReorderColumns(#"Added Custom",{"System ID", "Cell#", "Part#"})
in
#"Reordered Columns"
Close and Load data back to Excel. Reload to your Access Table.