Using the above Cross Apply where we have 3 rows coming back, is there a way to tell it to only send only one row instead of three based on...

Is this an Access question or a SQL Server question? I'm asking because SQL Server uses single quotes to delimit text strings and Access uses double quotes. If you're writing...

(Shows how much I understand about FOR XML... is there a good book on the bare necessities you need to understand about XML in SQL Server?)

But you could create a table and write the values from the DMV into it... Then you could look at it over time. Not sure it's worth doing, but that's...

Use a TVF like DelimitedSplit8K to break out the pieces, sort them then reassemble using STUFF.

step 1: find all the names that are not null 
step 2: union them together.
insert the result from step 2 into your final table.
return results from final table....

How about
CREATE TABLE Meeting (
    MeetingID INT IDENTITY PRIMARY KEY,
    MeetingType VARCHAR(20) NOT NULL,
    StartDateTime DATETIME,
    EndDateTime DATETIME...)

And then...

A little normalization goes a long way. If a single record describes ONE meeting, then this is trivial.

Oh, right... funny, I totally forgot about Kenneth Fisher's example of using CROSS APPLY to unpivot. (See me still thinking in terms of Access??!! BLECH!!)

One way of doing it is like this:
(this is a sample bad table)
CREATE TABLE DiagnosesBad (
    PatientID INT NOT NULL,
    Cycle TINYINT NOT NULL,
    Diagnosis9_1 VARCHAR(20),

Yes, it does.
SELECT  dbo.mdhomadm.Patient_Number, dbo.mdhomadm.Diagnosis9_1, dbo.mdhomadm.Diagnosis9_2, dbo.mdhomadm.Diagnosis9_3, dbo.mdhomadm.Diagnosis9_4, dbo.mdhomadm.Diagnosis9_5,
   dbo.mdhomadm.Diagnosis9_6, dbo.mdhomadm.Diagnosis9_7, dbo.mdhomadm.Diagnosis9_8, dbo.mdhomadm.Diagnosis9_9, dbo.mdicdcde.ICD_Code_Description
FROM  dbo.mdhomadm LEFT OUTER JOIN
   dbo.mdicdcde ON dbo.mdhomadm.Diagnosis9_1 = dbo.mdicdcde.ICD_Code

The problem is...