'Splitting SharePoint List [Request] into Subsidiary SharePoint List Based on Concatenated Colmun in Primary Sharepoint

a newbie here and working on a project for my work and i wonder if there is any one has any knowledge to how-to Split SharePoint List [Request] into Subsidiary SharePoint List Based on Concatenated Column in Primary SharePoint just to make sure that you got the image right here is what i want to do:- Created a [PowerApp] to make a request, and the way it's handled the user can choose multiple items in the primary sharepoint list "Concatenated" in one column, on the other side there is someone who handles these request and i would like to breakdown this "Request Concatented Colum" into another "Subsidiary SharePoint List" sharing the same Unique identifier that was created for the request but it has to be as (ROWS).. if anyone got any idea of how it may be done, will be very much appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source