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
1 Reply
Hi
See attached file.
