May 25, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

[Power Query] add data from 1 query into another query as a column

I have an excel file in which 2 queries were made to clean up the data:

Query 1:
Name | Date | Tank | quantity

Query 2:
Date

Issue: query 1 has (null) (Date column) values, so query 2 is needed to be added.

I tried append, it adds the query as a row but not column. In addition I tried merge but it requires matching data which is not possible in my case.

If there is sth like append for columns that would be great.

Check out the full article on the original site

#Excel alternatives for data analysis

#generative AI for data analysis

#big data management in spreadsheets

#conversational data analysis

#real-time data collaboration

#intelligent data visualization

#data visualization tools

#enterprise data management

#big data performance

#data analysis tools

#data cleaning solutions

#Excel compatibility

#Excel alternatives

#rows.com

#natural language processing for spreadsheets

#row zero

#Power Query

#Excel

#queries

#data cleaning