Power query append specific from multiple table

[mhdilyas2008]

I have imported data from multiple data source, now i want to append specific column from all data source instead of all columns

[v-jingzhang]

Hi @mhdilyas2008 

If you want to remain only the specific column in the final result, you can remove all other columns except that column in all queries, then rename the specific column into the same name. At last append all queries. 

Choose or remove columns - Power Query | Microsoft Learn

Append queries - Power Query | Microsoft Learn

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.