Forum Discussion
Find different value pairs in a table.
This is a sample of 1037 rows of report data from a medical database: The first column is Ethnicity, second, Race.
| Mexican American | Patient Declined |
| Hispanic or Latino/Spanish | Mexican American Indian |
| Latin American/Latin, Latino | American Indian or Alaska Native |
| Mexican | American Indian or Alaska Native |
| Mexican | Mexican American Indian |
| Not Hispanic or Latino | American Indian or Alaska Native |
How do I turn the preceding into this:
| Mexican American | Hispanic |
| Mexican American Indian | Native American |
| American Indian or Alaska Native | Native American |
| American Indian or Alaska Native | Native American |
| Mexican American Indian | Native American |
| American Indian or Alaska Native | Native American |
It's difficult for an 'American Indian or Alaska Native' to be 'Latin American/Latin, Latino' but this is the wild and wacky world of medical Ethnicity and Race.
Would appreciate any suggestions on how to generate the second table via VBA.
bcdozier
Hi
See attached file.
