•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I create a table with days in the columns, locations in the rows, and program names and times in the cells?
I need to create something like this image, without doing it manually (hopefully). I need the days of the week as headings on the x axis, locations on the y axis, and then program name and time of program in the cells. I've tried using a pivot table, but the values field won't show the text only calculations. There are over 5,300 events, but I need it summarized down to this to give to the marketing team. I would also like to be able to edit with additional notes if needed. Any ideas other than copy and pasting this manually into a grid?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives for data analysis
#real-time data collaboration
#real-time collaboration
#Excel alternatives
#table
#pivot table
#program names
#days of the week
#summary
#times
#locations
#events
#values field
#cells
#edit
#headings
#summary table