Need Help with Excel Spreadsheet

BusterCLARK 

Another Power Query option (attached)

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    SplitByLineFeed = Table.ExpandListColumn(
        Table.TransformColumns(Source,
            {"Job", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv),
                let
                    itemType = (type nullable text) meta [Serialized.Text = true]
                in
                    type {itemType}
            }
        ),
        "Job"
    ),
    GroupedJobCount = Table.Group(SplitByLineFeed, {"Job"},
        {"JOB_COUNT", each Table.RowCount(_), Int64.Type}
    ),
    FilteredJobCount = Table.SelectRows(GroupedJobCount, each [JOB_COUNT] > 1),
    RemovedJobCount = Table.RemoveColumns(FilteredJobCount,{"JOB_COUNT"}),
    MergedTables = Table.NestedJoin(
        RemovedJobCount, {"Job"},
        SplitByLineFeed, {"Job"},
        "COMMON", JoinKind.Inner
    ),
    ConcatClients = Table.AddColumn(MergedTables, "Clients", each
        Text.Combine([COMMON][Client], ", "), type text
    ),
    RemovedColumn = Table.RemoveColumns(ConcatClients,{"COMMON"})
in
    RemovedColumn