IHi
I have 2 tables in a file called File1. I opened a new file called File2 and then went to Data-->From File and Get these 2 tables from File1. So I have 2 queries now Q1 and Q2. In PowerQ editor-->Home-->Merge-->New. I merged these 2 Queries. Now I have 3 Queries, Q1,Q2 and Merge. When I Close and Load to -->Pivot Table Report, I will get these 3 tables listed in Pivot Table. Can I just Load one table for example Merge table but not the other ones. That is possible in Power BI but I could not figure that out in Excel. Thank you very much.
I have 2 tables in a file called File1. I opened a new file called File2 and then went to Data-->From File and Get these 2 tables from File1. So I have 2 queries now Q1 and Q2. In PowerQ editor-->Home-->Merge-->New. I merged these 2 Queries. Now I have 3 Queries, Q1,Q2 and Merge. When I Close and Load to -->Pivot Table Report, I will get these 3 tables listed in Pivot Table. Can I just Load one table for example Merge table but not the other ones. That is possible in Power BI but I could not figure that out in Excel. Thank you very much.