We help IT Professionals succeed at work.

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

Patricia Timm
Patricia Timm asked
on
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

View Solution Only

Tom FarrarConsultant

Commented:
Use Data>From Table
Consultant
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.
Patricia Timm

Author

Commented:
Thanks