Tricky formula needed to format multiple columns into one cell

Insert a column to the left of the data

Copy the header cells and transpose to the inserted column

Select the data column, Data > Text to columns, select Delimited, and tick Comma as the delimiter.

      --------A-------- B- C- D- E- F- G-
  2   Size               5  6  7  8  9 10
  3   Quantity          11 22 33 44 55 66
  4   Price Increase     0  0  0  0  0  0
  5   Additional Weight  0  0  0  0  0  0
  6   Sort Order         1  2  3  4  5  6