Excel Queries

[Sahak]

Hi All,

If I have some data (say 1,000 rows & 20 columns) on Sheet1, and some data (say 1500 rows & 12 columns) on Sheet2, how can I make queries ?
Thank you in advance

 

[sandy666]

queries of what?

if with PowerQuery load both tables into PQ Editor then do whatever you want

 

[Sahak]

queries of what?

if with PowerQuery load both tables into PQ Editor then do whatever you want

Hi sandy666,

Thank you very much for reply.
Im week with queries, could you explain how to load tables into PQ Editor, by the way my Excel is 2007.

Thank you in advance.

 

[sandy666]

PowerQuery add-in: Excel 2010 / 2013
PowerQuery built-in: Excel 2016 / 365 /2019

so if you want to use PowerQuery - upgrade your Office

Mac is not supported (yet )

 

[Sahak]

Thank you very much.

 

[sandy666]

You are welcome

Have a nice day