Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
113
Views
Topic starter
Hi,
Please find attached file.
Thanks
Posted : 26/03/2024 11:11 am
Hi Kagiso,
Data query combines 2 tables: Transactions and Budget. If the 2 tables don't have the same structure (headers), the table that is missing headers will have null values in those columns.
The budget table has only 3 columns, no Transaction date, therefore there will be no Year/ Months for the records coming from this table:
Posted : 30/03/2024 4:06 am
Topic starter
Hi Catalin,
WOW, I was able to do the adjustments to match the two tables and I'm happy to say there are no blanks.
Thanks, your feedback was very helpful
Salute!!!
Posted : 30/03/2024 9:16 am