Hi, I need some help combining multiple records when the ProviderNPI matches another record. Here is some information from my table:
LastName ProviderNPI GroupName GroupNPI Potter 1538340682 Christ Community Health Services, Inc. 1053572206 Potter 1538340682 Christ Community Health Services, Inc. 1841513058 Potter 1538340682 Christ Community Health Services, Inc. 1982686614
as you can see I have 3 records with the same LastName, ProviderNPI and GroupName; but the GroupNPI is different for each record.
I would like to combine these into one record to look like this:
LastName ProviderNPI GroupName GroupNPI Gr2_Name Grp2_NPI Gr3_Name Grp3_NPI Gr4_Name Grp4_NPI Potter 1538340682 Christ Community Health Services, Inc. 1053572206 Christ Community Health Services, Inc. 1841513058 Christ Community Health Services, Inc. 1982686614
Thanks,
Lisa