Adding a column and filling it with a fixed value from a cell in an Excel file

[Anonymous]

I need to add a column to a PowerQuery, and fill it with a fixed value contained in a specific cell in the source Excel file. How do I do that?

[mahoneypat · Accepted solution]

You can create a second query (e.g., ExcelQuery) to pull the data from your Excel and drilldown to the specific cell, so that query returns a single text or numeric value (not a table). You can then add a custom column to your original query and put "= ExcelQuery" in the pop-up box (w/o quotes).

Pat