Sheets can take a table from a web page by paste or by formula. Which one fits depends on whether you need the data once or kept up to date.
Use =IMPORTHTML("page address", "table", 1). The number picks the table, counting from 1. Sheets refreshes it about once an hour. It cannot read pages that need you to sign in, or tables that a script draws after the page loads. Those show up as an error or an empty result.
Many sites draw grids with div elements. Copy and IMPORTHTML both miss those. A table copier extension such as Table to CSV & Excel – Table Copier reads grids built from rows and columns of div elements as well, and gives you tab-separated text that pastes into Sheets cleanly.
Set the destination columns to Plain text before pasting, then convert them on purpose with Format, then Number, then Date.
Fill the blanks down with a formula such as =IF(A3="",A2,A3) in a helper column.
Use =TRIM(A2) in a helper column and paste the values back.