•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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com