# Calendar from multiple tables **URL:** \ **Category:** Ask for Help\ **Created:** [September 24, 2024, 5:37pm UTC](https://community.glideapps.com/t/calendar-from-multiple-tables/76595 "2024-09-24T17:37:50Z")\ **Posts on this page:** 1\ **Showing post:** 4
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 25, 2024, 11:59pm UTC](https://community.glideapps.com/t/calendar-from-multiple-tables/76595/4 "2024-09-25T23:59:52Z")
I think you can explore something like this: - A query to get all “favorited” events from “Talks”. - A query to get all “favorited” events from “Overview”. - A lookup to get all favorited rowIDs from “Talks”. - A lookup to get all favorited rowIDs from “Overview”. - A Make Array column to join those two lookups into a single array of rowIDs. > [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766): > > I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc) Use this method to transpose that list of IDs in a new helper table. Add as many rows as you might need. - Use two relations to try to link each rowID back to their “Talks” and “Overview” table. - Use lookups to pull over titles, start times and end times from each relation. - Use if-then-else columns to get the final titles, start times and end times (since only one from each pair of columns for those can contain a value). - Use those values for your Calendar. --- _[View the full topic](https://community.glideapps.com/t/calendar-from-multiple-tables/76595)._