How to link individual attributes in one sheet to the list of attribute which has details

[Anonymous]

I have to link the columns L to the end with a list of attribute to a supporting sheet.

Column A cells have the names of the colum L-X in the previous sheet and I have make a relationship between them.

[amitchandak]

@Anonymous , With data not very clear. But you have to merge in power query, maybe more than once

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

or bring data in the table, deal with 2 tables at a time

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8