Transposing Columns by Key/Value

You can transpose columns into rows using key/value pairs to the previous status.

Note: Before transposing columns, you must fill in all the empty cells. To fill in the empty cells, click Edit cells > Fill down from a column menu.

To transpose Dimension and Measurement columns back to the Height, Width, Depth, and Weight columns:

Procedure

  1. Click Edit cells > Fill down from a column menu to fill in all the empty cells.
    In this example, fill in empty cells in the ItemID, Item, Color, Materia, Origin, Price columns one by one.
  2. From the Dimension column menu, click Transpose > Columnize by key/value columns.
  3. Specify the key and value columns:
    1. In the Key column area, click Dimension.
    2. In the Value column area, click Measurement.
  4. Click OK to start the transposition.