Hi
A colleague wants to take the combination of the values in SPC_Area_Name, SPC_Park_Name, Park Type (lookup) and return the value from SPC_Specialist_First_Name into a matrix. The result will return the name of the person responsible for a particular Park and Park Type.
Please refer to the attached spreadsheet TAB named Query for the data set.
Thanks for your help in advance.
Gary
Maybe this post should have been put into the General section. Is it possible to have it moved please?
Hello,
I am really not sure if I understand correct, but attached file shows what I would do if I had such list.
Using a PivotTable is great for many scenarios.
Br,
Anders
Hello Anders
Thank you for your response.
I will take your spreadsheet to my colleague to see if it what they were after.
Kind Regards, Gary
