We help IT Professionals succeed at work.

Merging two tables located on the same worksheet using power query.

Merging two tables located on the same worksheet using power query. I have a get external data option but dont see the get table/range option.... I place my cursor in the cell where the table exists to start out with and the options I have are from access, web, existing connections, etc
Comment
Watch Question

Commented:
Use Data>From Table
Commented:
Data>Get & Transform>From Table.  Also see my other post on "From Folder".  The problem (hard to believe) may be from folder does not work for Excel, but will work if you save as a .csv file.

Author

Commented:
Thanks