L
Legacy 327817
Guest
Hello,
This one might be a little complicated but I was curious if anyone knew an easy way to accomplish this.
I have a table that looks like the following:
Column A_____________Column B
1) Ambulatory_________99201, 99202, 99203, 99204, 99205, 99211, 99212, 99213
2) Testing_____________87070, 87071, 87081, 87430, 87650, 87651, 87652, 87880
3) Cancer Screening____88141, 88142, 88143, 88147, 88148, 88150, 88152, 88153
4) Prenatal Care_______99201, 99202, 99203, 99204, 99205, 99211, 99212, 99213
Column A is descriptions, and Column B is 5 digit codes separated by a comma. What I want to do is to create a table by Code. For example:
Column A_____________Column B
99201________________Ambulatory,Prenatal Care
99202________________Ambulatory,Prenatal Care
22903________________Ambulatory,Prenatal Care
88141________________Cancer Screening
88412________________Cancer Screening
etc...
Another issue is that one code may appear multiple times, as you can see above. I would like for the table to look at all the codes and return the descriptions that corresponds with it. (Either have the descriptions in the same column like above or separate, doesn't matter)
Is this too complicated? I know there are probably multiple steps in this issue but I am not even sure how to start. Any help would be appreciated.
Thanks!!
This one might be a little complicated but I was curious if anyone knew an easy way to accomplish this.
I have a table that looks like the following:
Column A_____________Column B
1) Ambulatory_________99201, 99202, 99203, 99204, 99205, 99211, 99212, 99213
2) Testing_____________87070, 87071, 87081, 87430, 87650, 87651, 87652, 87880
3) Cancer Screening____88141, 88142, 88143, 88147, 88148, 88150, 88152, 88153
4) Prenatal Care_______99201, 99202, 99203, 99204, 99205, 99211, 99212, 99213
Column A is descriptions, and Column B is 5 digit codes separated by a comma. What I want to do is to create a table by Code. For example:
Column A_____________Column B
99201________________Ambulatory,Prenatal Care
99202________________Ambulatory,Prenatal Care
22903________________Ambulatory,Prenatal Care
88141________________Cancer Screening
88412________________Cancer Screening
etc...
Another issue is that one code may appear multiple times, as you can see above. I would like for the table to look at all the codes and return the descriptions that corresponds with it. (Either have the descriptions in the same column like above or separate, doesn't matter)
Is this too complicated? I know there are probably multiple steps in this issue but I am not even sure how to start. Any help would be appreciated.
Thanks!!