| Course | Term | Pell Recipient | WU | # DFW | # Total Students | % DFW |
| ECON 0101 01 | Fall 2017 | Not Recipient | 1 | 13 | 46 | 28% |
| ECON 0101 01 | Fall 2017 | Pell Recipient | 1 | 6 | 36 | 17% |
| ECON 0101 02 | Fall 2017 | Not Recipient | 0 | 18 | 85 | 21% |
| ECON 0101 02 | Fall 2017 | Pell Recipient | 0 | 19 | 52 | 37% |
Hi Everyone, I have data in this format, but I have been told to basically create, for example, one row that consists of course (econ 101 01), term (fall 2017), and then 8 new columns, Pell WU, Pell #DFW, Pell # Total Students, Pell %DFW, and then non-Pell versions of those columns. Please tell me there's an easy way to do this. Thank you.
