Forum Discussion
Use Multiple columns as filter
I've been lurking in the forums, finding all kinds of neat things to do with a scheduling spreadsheet we use, so thank you all for questions and responses you've posted! I have a question that I can...
erikmitchell You need to change your data entry table into a flat table where there is only one column for "leader type" and the values are "leader 1", "leader 2", etc. Then you need another column for the user name. If an event has three leaders, then that event will have three entries in the data entry table.
THEN you can build a pivot table that is filtered by the User.
IngeborgHawighorst Thanks for responding
Sorry, What do you mean make it a flat table?
