Need to split distinct value from a single row need dynamic solution based on commo separated value

I have one column within table that have value like "Input" as we have same value like xyz and pqr but on output section only single value will be appear I need a output like shown below but using ...