Hello!
I am struggeling to visualise my data.
Weekly i receive a list with a date stamp and a zipcode.
The zipcode is for me easy to recognize the related store.
So, is there any way to visualise the zipcode vertical and the date stamp horizontal? So i can do a Vlookup with the store name and have a clear overview?
I want to see all visits on same zipcode within 21 days.
I find it hard to share all needed information as i feel its very vague - hope someone can help me out.
Well, you could start by sharing some example data. Replace any confidential information, like real names, with made-up ones. You can upload a file with your response. Select 'Attachments', select the file and press 'Start Upload'. Wait until it's done and then 'Submit Reply'.
And what Excel version are you working with?
Hi Riny,
It seems i can't replace the old file - as the pop-up doesn't display anything.
Here is my new file.
I've added a shop name to make it more realistic.
I work in O365 - i guess the newest version...?
Hi Kevin,
Your file didn't upload. After selecting the file, you need to click the 'start upload' button and then wait for the grey check mark before submitting your reply.
Mynda
Hi Myanda,
Sorry, i thought i did.
You should also note that if you cross-post to multiple forums, etiquette dictates that you provide all links in each forum so that people don't duplicate effort or waste time on a question that may have been resolved elsewhere.
Cross-posted here:
https://www.excelforum.com/excel-charting-and-pivots/1427102-structure-to-visualize-data.html
