Here we go...
First off, I am using Windows 7 Enterprise, Excel 2013 on a PC.
Here is what my data looks like:
Here is what I would like it to look like:
This would be sufficient, but what I would REALLY like to do is, like with the row with the BIO courses, I have two courses there separated by a "/". I would also like for anything after a "/" to become a new row, like so:
I hope this enough information to start getting some help.
Thanks in advance!
First off, I am using Windows 7 Enterprise, Excel 2013 on a PC.
Here is what my data looks like:
| A | B | C | D | |
| 1 | EKU Class | Class Name | KCTCS Class(es) | Core Category |
| 2 | BIO 100 | Biology 1 | BIO 150 + BIO 151/BIO 101 | Natural Sciences |
| 3 | ENG 100 | English 1 | ENG 095 | Written Communication |
| 4 | COM 101 | Communications 1 | CMS 200 | Oral Communications |
| 5 | CIS 100 | Computer 1 | CIT 105 | Computer Class |
Here is what I would like it to look like:
| A | B | C | D | E | F | |
| 1 | EKU Class | Class Name | Natural Sciences | Written Communication | Oral Communictions | Computer Class |
| 2 | BIO 100 | Biology 1 | BIO 150 + BIO 151/BIO 101 | |||
| 3 | ENG 100 | English 1 | ENG 095 | |||
| 4 | COM 101 | Communications 1 | CMS 200 | |||
| 5 | CIS 100 | Computer 1 | CIT 105 |
This would be sufficient, but what I would REALLY like to do is, like with the row with the BIO courses, I have two courses there separated by a "/". I would also like for anything after a "/" to become a new row, like so:
| A | B | C | D | E | F | |
| 1 | EKU Class | Class Name | Natural Sciences | Written Communication | Oral Communictions | Computer Class |
| 2 | BIO 100 | Biology 1 | BIO 150 + BIO 151 | |||
| 3 | BIO 101 | |||||
| 4 | ENG 100 | English 1 | ENG 095 | |||
| 5 | COM 101 | Communications 1 | CMS 200 | |||
| 6 | CIS 100 | Computer 1 | CIT 105 |
I hope this enough information to start getting some help.
Thanks in advance!
