1 min readfrom 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.

submitted by /u/dauntlessMast
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com