One possible solution is to actually use a background image of the shelf layout and box out the spots on the shelves. The video Background Images goes over the whole process to use that method.
Resolving the issue where a product that should show in two grid positions is only showing in one in a crosstab depends on exactly how the data is structured and how the view is set up. Would it be possible to post a packaged workbook showing what you have? Maybe with sample data if the data is sensitive?
I hope this helps!
Hi Esther - that is perfect, thank you!! This is just what I was looking for I'll have a play around and share a packaged workbook if I can't get the data to work, but I'm pretty sure I won't have any more problems - this is just what I was after.