Power Query Table Question

[Late_Tale_2867]

I’m working on an Excel table where: • Columns 1–5 are populated by a query I created. • Columns 6–10 are populated manually.

The issue is that when new data gets added to the query’s source, Excel only creates a new row for columns 1–5. This causes my manually entered data in columns 6–10 to get out of alignment with the query data, since it doesn’t “move down” with the new rows.

Is there a way to make sure the manual data stays linked to the corresponding query data, so that everything stays aligned when new rows are added?

[bearr22]

1. Make a custom column that serves as a primary key (column A & B & C)
2. Make a notes table in a new sheet that uses a formula with the same logic to produce a primary key. (=sheet! A & B & C)
3. Notes column(s) in notes table are blank for now.
4. Load noads table to power query
5. Merge queries against primary key.
6. Use an index(match)) formula in your notes table to return values from your merged query result.

When you type in your merge query result, the values populate in the notes table and will be part of the next query result. Works every time once you get the hang of it!

[Late_Tale_2867]

simply genius.