Sometimes data is not arranged into rows and columns the way you like. Indeed, there are different ways of arranging what belongs where, and the choices depend on the situation. In the Powerhouse Museum dataset, for instance, there are separate columns for several dimensions: Height
, Width
, Depth
, Diameter
, and Weight
. However, not many objects have data for these columns, so the cost of maintaining them might be high with respect to the value they add. An alternative would be to transform these five columns into two columns: one that contains the name of the dimension (for instance, Height
or Weight
) and another that contains the measurement (for instance, 35mm
or 2kg
).
What we want to do here is to transpose the columns into rows. To do this, click on the Heigh t dropdown and navigate to Transpose | Transpose cells across columns into rows…, which will bring up the following dialog:
On the left, you can choose from the From Column, the column from...