LOOKUPVALUE with multiple results

Thank you PattemManohar for your suggestion, I have tried this and it has worked and provided all results into one cell.

Thank you Ashish_Mathur for your suggestion to merge the queries. As I am quite new to Power BI, I wasnt familiar with how this worked but have managed to also replicate a solution using this function. My question now is that now I have structred the data in a way where i have a table of results within Table 1. Is there a way to print the contract ID list of results in table 1 with each contract ID having its own column. The customer/plan table may have a varied different number of results (max would be 10).

Table 1

Customer/Plan (As-Is) table (row 1) within Table 1

Example output...

Customer/Plan (As-Is)          Contract ID1       Contract ID2       Contract ID3     Contract ID4

8300002592_AF                   T-009141            T-001871             T-0018172      T-18191

Thanks.