As a newbie I think I am over my head a bit but all research is leading me to having to enter a double eval and concat to a repeating table so the data can be exported from a SharePoint list to Excel.
I have added a repeating table (tried to repeat the layout below) so the submitter would enter, for example, Camera (Item), Head Office (Centre), ...