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...

Can you post a CREATE TABLE script and the INSERT scripts for this?
And maybe fix up your SQL so we can read it?

This should get you started. Since you're new here, I created your table and added some data. If you want a tested answer, you should provide this.
CREATE...

Okay, thanks!  (Finally got the e-mail from my database!... where do they go when they get lost between my computer and gmail?) So I know the code works...
Guess...

I'll have a read. From a quick scan, I'd basically have to use a unique subject and search for that and the recipient's e-mail in the table, and if not...