This data as .json
| rowid | event_id | name | clean_description | location_room | start_date_clean | start_time | end_time | pre_reg_flag | paid_flag | laptop_flag | speakers_cleaned | session_type | keywords | skill_level | session_title |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70 | 4266 | Excel: Using string functions to reformat data | Maybe you converted a PDF or imported a table into Excel -- or maybe an agency gave you a poorly formatted file. You can use string functions to reformat your data and get your spreadsheets working for you. This session is good for: Anyone comfortable with using formulas in Excel. | 4 | 2019-03-07 | 2019-03-07 15:30:00 | 2019-03-07 16:30:00 | 0 | 0 | 0 | Rachel Alexander, Salem Reporter | 3 | 4 | Excel: Using string functions to reformat data |