reminder of Advanced -> Relationships to configure View to JOIN CiviCRM Entities would have been helpful
https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/
After the View is created, edit the fields, filters, display and other configurations to show the data exactly how you'd prefer. Use the Advanced -> Relationships options to JOIN multiple CiviCRM Entities to select data from additional tables, exposing that data from the Fields option in the View. Views does take some experimentation and/or training to get it right. Feel free to ask questions on Stack Exchange or Mattermost — or hire a consultant if you become stuck.