Forum Discussion
Solved
Merge / append two columns from 2 tables
Hi all I have seen various iterations of this topic on the forums but none meet my sepcific requirement. I have two tables: Table A Name SerialNumber Hostname1 PC0TKV9P Hostname2...
algorton In your Power Query Editor, edit the query for your 2nd table and remove your OS Version and Manufacturer columns. Then Append the queries.
Hi,
Only change the column names in Power Query before the Append. In the table B, instead of 'Device name', switch it to 'Name' (as in the table A) and 'Serial Number' to 'SerialNumber'.
Once Appended, you can keep only these two columns.
Hi,
Only change the column names in Power Query before the Append. In the table B, instead of 'Device name', switch it to 'Name' (as in the table A) and 'Serial Number' to 'SerialNumber'.
Once Appended, you can keep only these two columns.