Unable to Merge queries due to dropdown issue

[bfreeman0]

Hi All,

I am having an issue where I want to use 'PowerQuery' to transform data. I open the Get Data option select two data sources which are both Excel files. Then when I click Merge Queries. the dialog box appears. But when I use the dropdown to select the second table, it won't allow me to select the table.

I'm using Microsoft Excel 365 version 2312 

[#2]

@bfreeman0 

On your screenshot there is no second table to merge