JSTallings
New Member
- Joined
- Sep 6, 2010
- Messages
- 2
I have a table with the following table:
<tbody>
</tbody>
Is it possible to add a fourth column that returns a "Yes" or "No" for each unique Jane and John if there is ever a "Yes" in both columns? I would ultimately like to filter a unique list of those students who have transferred.
<tbody>
</tbody>
Longer question:
I am pulling information from a large dataset on our graduates. Every time a student drops out, transfers, or graduates, another row is added with ID#, name, dates, etc. The schools are numbered 1, 2, 3, based on the sequence of the student's enrollment. I am using Power Query successfully to append new data, but obviously nothing is normalized.
The "Yes" and "No" come from a calculated column in PowerPivot that simply returns a "Yes" in column C if a student started in a community college (it is a community college and numbered "1") and a "Yes" in column B if they transferred to a university (it is a university and numbered >1). The larger issue is that each student may have over 14 rows as they move through their degrees.
Can anyone help me in my ignorance? I have a related, normalized table with the students' names, ID numbers and such; since the transfer only happens once, maybe that is a good place for the information rather than repeating it all over the place?
Thank you!
Student_Name | Transfer | Community_College |
Jane Doe | Yes | No |
Jane Doe | No | Yes |
John Doe | No | No |
John Doe | No | No |
<tbody>
</tbody>
Is it possible to add a fourth column that returns a "Yes" or "No" for each unique Jane and John if there is ever a "Yes" in both columns? I would ultimately like to filter a unique list of those students who have transferred.
Student_Name | Transfer | Community_College | Transfer |
Jane Doe | Yes | No | Yes |
Jane Doe | No | Yes | Yes |
John Doe | No | No | No |
John Doe | No | No | No |
Bill | No | Yes | No |
Bill | No | Yes | No |
<tbody>
</tbody>
Longer question:
I am pulling information from a large dataset on our graduates. Every time a student drops out, transfers, or graduates, another row is added with ID#, name, dates, etc. The schools are numbered 1, 2, 3, based on the sequence of the student's enrollment. I am using Power Query successfully to append new data, but obviously nothing is normalized.
The "Yes" and "No" come from a calculated column in PowerPivot that simply returns a "Yes" in column C if a student started in a community college (it is a community college and numbered "1") and a "Yes" in column B if they transferred to a university (it is a university and numbered >1). The larger issue is that each student may have over 14 rows as they move through their degrees.
Can anyone help me in my ignorance? I have a related, normalized table with the students' names, ID numbers and such; since the transfer only happens once, maybe that is a good place for the information rather than repeating it all over the place?
Thank you!