Forum Discussion
Excel Power Query
Farrah_Twigg On 1, there are several techniques to achieve this. Google for "manual column power query" and you'll find them. E.g. this one:
On 2, a SPILL error suggests that the formula tries to output to more than one cell at once and that the output range is occupied by non blank cells. Alternatively, you have entered a dynamic array formula inside a structured table.
Riny_van_Eekelen this, unfortunately, doesn't solve the problem for what I'm trying to achieve.
Effectively, what I am trying to create on Sheet A. is a bingo matrix for a sales team to see all of their accounts and what products/services they have. Sheets B, C & D have the technical information for particular products. My Power Query tab (Sheet A) is pulling through the customer name and a total column from sheets B, C & D. What I then want to do on Sheet A is add extra columns for information that the sales team can populate.
Farrah_Twigg Difficult to help without seeing the file. Hard to imagine what a "bingo matrix for a sales team" is. And as said, there are other methods to do such things in PQ.