Hi,
Mods, please let me know if this post should be migrated to another topic forum if I have mistakenly placed this in the wrong place.
So I have columnar data, the perfect data for a database. However, I'm not working with a database, and in order to import into this data into a backend CMS for an event's mobile application, I need to convert this data in a useable horizontal/row-based format in excel. Some of this can be done using some quick formulas in excel, which have proved extremely time saving. However, some of the data doesn't quite format well. The reason is that the data is based on the least common denominator of Presentation Name, rather than sessions.
I have attached an example to this thread of what I mean by columnar data. However, the basic idea is that speakers are arranged vertically by presentation Name, with a Speaker. This means that silos of sessions are created. I can filter for multiple sessions in my horizontal format rather quickly, but I would like to take the Presentation Name, Presentation Start Time, Presentation End Time, and Speaker Display Name and place it into a single excel field using an Access report and export. Is this a possibility? Are there any better ways to do this beside manual entry(I have thousands of rows)?
Please let me know your thoughts, and thank you in advance!
Sincerely,
dabuse