Join 2 columns in one table based on equal values in a third column

I am trying to separate data within one column based on identical values in a second column. Our goal I to find out how many times each MD used a facility. Unfortunately, the table has separate entries for location and MD but identifies each with a common Document ID

Description Text Document_ID MDname Smith 13467 Facility Providence 13467 MDname Jones 14657 Facilty Charity 14657 MDname Smith 19834 Facility Providence 19834 MDName SMith 18777 Facility Charity 18777

Convert to Smith Providence Jones Charity Smith Providence Smith Charity

Convert to

Smith Providence 2 Smith Charity 1 Jones Charity 1

Is there a join that will join 2 columns within 1 table , using a common value of a third column ??