Data > Stack > Rows

Complete the following steps to stack data from a set of rows into a column.

  1. In Rows to be stacked are in the following columns, enter the columns that contain the data that you want to put into a single column.
  2. In Store stacked data in, enter a column number (for example, C6) or a column name in which to store the stacked data. If the column name has more than one word, enclose the name in single quotation marks.
  3. To store row subscripts, select Store row subscripts in, then enter a column number (for example, C7) or a column name. If the column name has more than one word, enclose the name in single quotation marks.
  4. To store column subscripts, select Store column subscripts in, then enter a column number (for example, C8) or a column name. If the column name has more than one word, enclose the name in single quotation marks.
  5. To include corresponding values from other columns with the stacked rows, select Expand the following columns while stacking rows, then enter the columns to expand.
  6. If you are expanding columns, in Store the expanded columns in, enter a column number (for example, C9) or name for each column that you are expanding. If the column name has more than one word, enclose the name in single quotation marks.

For example, in following worksheet, the data in the Seattle, Boston, and New York columns are stacked into the Sales column. The Qtr column contains the row subscripts and the City column contains the column subscripts. The column Advertising is expanded into the column Adv.

C1 C2 C3 C4 C5 C6 C7 C8-T C9
Quarter Seattle Boston New York Advertising Sales Qtr City Adv
1 63 36 52 63 63 1 Seattle 63
2 71 32 46 75 36 1 Boston 63
3 68 35 51 68 52 1 New York 63
4 66 29 50 79 71 2 Seattle 75
          32 2 Boston 75
          46 2 New York 75
          68 3 Seattle 68
          35 3 Boston 68
          51 3 New York 68
          66 4 Seattle 79
          29 4 Boston 79
          50 4 New York 79
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy