Transposing Columns by Key/Value

After transposing cells across column into rows, you can change your data to the previous status.

Note: If some cell values are empty after transposing cells across columns into rows (See Transposing Cells Across Columns into Rows), you must fill in all the empty cells before performing the columns transposing by key/value operation. 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. Here, fill in empty cells in the ItemID, Item, Color, Materia, Origin, Price columns one by one.
  2. From the Dimension column menu, click 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.
Contents
Search Results