How can I copy data from multiple rows and columns and paste it into one column efficiently?

Viewed 17

I have a dataset of house prices from 2000 to today in all 50 states. I tried pasting the data manually into one column, but it ended up being tens of thousands of rows. I would like the data in a single "Price" column without having to paste every quarter of data.

Images: Price Data, State and price columns

0 Answers
Related