i have duplicate the data in the table and union it , then grouped it based on data sources.
this solution is used for less data and fixed number of groups.
please find the attached workbook for reference.
Actual data :
Creates New column as : New category
Viz with filter null on New category :