•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?
Our take
Creating a structured table with days as columns, locations as rows, and program names and times in the cells can streamline your data presentation. To achieve this without manual input, consider using a combination of functions like INDEX and MATCH in Excel or Google Sheets. This approach allows you to automatically pull relevant data from your existing dataset. Additionally, you can format the table to include editable notes, ensuring it remains flexible for your marketing team’s needs. Let’s explore how to set this up efficiently.
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]
Read on the original site
Open the publisher's page for the full experience
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