Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you want to make the title more readable, you can select all cells in the sheet (click on the icon in the top left-hand corner of the cells) and then click "Wrap Text" on the "Home" tab.


Your cells should now expand (downwards). Now, click into cell A2 (highlighted in red in the screenshot below). In that cell, enter in the following formula: =CONCAT("[[sort]]
",B2). After you insert the formula in the cell, click the "Enter" button in order to finalize the formula.

Image Added


Your formula should now be established in cell A1. It should read as "[[sort]] (line space) (Grant Number from the same row in column B)." Now, we need to populate the rest of the cells in column A. Move your cursor to the bottom right-hand corner of cell A2 until your cursor changes into a tiny black cross. When it does so, double click your mouse. This will populate all of the cells in column A with the formula you entered into cell A2. That will complete the creation of the T-4 Sortable Element column. Please also see the screenshot below for further instruction.

Image Added

Concatenate the Health Topics Columns into One

Next, scroll over to the right until you see the columns "Health Topics (OAC)" and "Health Topics (PERC)" (should now be columns T & U).

Image Added


After that, right-click in column T (right above the header) and then click on "Insert" from the menu that appears. This will create a new cell to the left of the cell Health Topics (OAC).

Image Added


In the newly created column, change the title of the column to "Health Topics." Then, click into cell T2. In that cell, enter into the following formula: =CONCAT(U2,V2). After you enter that formula in the cell, hit the "Enter" button on your keyboard to finalize the formula.

Image Added


Now, move your cursor to the bottom right-hand corner of cell T2. When your cursor becomes a small, black cross, double click with the left mouse button. This will populate this formula into every cell in column T for your table.

Image Added