I would like to create a report that takes a list of people's names with
their tasks and place this information into a matrix. Let me explain with
the following information:

In sheet 1, I have a table that has the following columns: Report Name,
Report Description, Dept Published By, Distribution Names
NOTE: The "distribution names" column data are written like this: Mark
Smith, Joe Johnson, David Jones, (etc)

In sheet 2, I have all a table that has the "Distribution Names" for the
y-axis and the "Report Name" in the x-axis.

Is there any way I can make a formula that would allow the data from sheet 1
populate into sheet 2?

Thanks!