Forum Discussion
Solved
Merge Question Between Data Tables with Shared Column
Hello Everyone, I am fairly new to Excel Power Query but I am really liking this tool and what it can do. I am currently using it to access an SQL database. I am familiar with how to Merge querie...
Rob, you may merge your first table with second one on WO_Description_ID and extract Remarks column. After that merge resulting table with second one on FINDINGS_ID and extract remarks as Remarks.1 column.
Select Remarks and Remarks.1 columns, on Power Query editor ribbon Add Column->Merge Columns, merge them with custom line feed separator #(lf). Or any one which you prefer. All remarks will be in resulting column.
Hi Rob,
Yes, it's better with screenshort or small sample which illustrates data logic. Like this