Forum Discussion
Grouping columns
Hello! I have a report that I generate at work that lists medications entered by various providers at our hospital. It will have a column for the medication name, a column for the dose, and a column f...
Hello PharmD ,
What you describe can be easily done with a Pivot Table. Select all the data, then click Insert > Pivot table. Now you see the pivot table pane. Here, drag the name into the "Rows" area and again into the Values area. The pivot table will now show the count of each individual name.