Forum Discussion
Solved
include value from column only if it includes the value of another column
I have a table laid out as below. Bldg ID Name CUF123 CUF main CUF456 CUF storage I have another table from another system with the same type of date only the id's are different. H...
Hi ahhollan
In Table 2,
Create a duplicate of the Name column in Power Query
Then use Split Column option with use as followRename the column header as per your require
Let me know, it solve your requrement
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Hi ahhollan
In Table 2,
Create a duplicate of the Name column in Power Query
Then use Split Column option with use as follow
Rename the column header as per your require
Let me know, it solve your requrement
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
That worked perfectly. Thanks for your help.
