Hi! I work with attendance data every week and don’t know much about Excel or how I can make things quicker and easier. I work with attendance data, which comes from our ticketing service in three columns – amount of tickets registered in each order, visitor zip code for those tickets, and the day of the week the tickets were for (see example below). Basically, I need the zip codes to each appear in a separate column the amount of times that a ticket is made with that zip code (so if there are 9 total tickets for the zip code 19107, the new column would have nine cells reading 19107). These new columns would represent the day of the week the ticket occurred (see second image below) From this point, I have shortcuts that make the data easy to work with for the purposes of my reporting, so no recommendations are needed for how to take the data forward from there. I just don’t want to have to individually type zip codes for the amount of times they occur. Please let me know what I can do or if further explanation is needed. 

​Hi! I work with attendance data every week and don’t know much about Excel or how I can make things quicker and easier. I work with attendance data, which comes from our ticketing service in three columns – amount of tickets registered in each order, visitor zip code for those tickets, and the day of the week the tickets were for (see example below). Basically, I need the zip codes to each appear in a separate column the amount of times that a ticket is made with that zip code (so if there are 9 total tickets for the zip code 19107, the new column would have nine cells reading 19107). These new columns would represent the day of the week the ticket occurred (see second image below) From this point, I have shortcuts that make the data easy to work with for the purposes of my reporting, so no recommendations are needed for how to take the data forward from there. I just don’t want to have to individually type zip codes for the amount of times they occur. Please let me know what I can do or if further explanation is needed.     Read More

​