Hello everyone!
I have scraped a bunch of data from Zillow and am trying to sort it all out.
I currently have the following columns:
What I'm trying to do is sort by columns. Since the output sheet dynamically pulls from the "source" sheet compiled from scraping, I can only sort on the "source" and have it pulled in to the output sheet correctly sorted.
I created an area called "Sorting Order" and have a numbered drop-down list of the columns I'd like to be able to sort through (8 options): Type, Sale Date, Sale Price, $ PSF, Beds, Baths, Square Feet, Year Built.
That way the sorting order is dictated by the order selected (cells J3:J8 on output sheet) with J3 = 1st sort order, J4 = 2nd sort order, etc. (6 sorting orders currently for formatting reasons, although not sure if we'd ever use more than 3 at a time)
Is there a way to get it to sort the data on the "source" sheet by applying the sorting order manually/dynamically by selecting the order from a drop-down list?
Hope I explained it well/clearly enough!
Thanks
Edit:
This is what the "source" sheet's column headers look like:
I have scraped a bunch of data from Zillow and am trying to sort it all out.
I currently have the following columns:
Street Address | City | State | Zip | Type | Sale Date | Sale Price | $ PSF | Beds | Baths | Square Feet | Year Built | URL |
What I'm trying to do is sort by columns. Since the output sheet dynamically pulls from the "source" sheet compiled from scraping, I can only sort on the "source" and have it pulled in to the output sheet correctly sorted.
I created an area called "Sorting Order" and have a numbered drop-down list of the columns I'd like to be able to sort through (8 options): Type, Sale Date, Sale Price, $ PSF, Beds, Baths, Square Feet, Year Built.
That way the sorting order is dictated by the order selected (cells J3:J8 on output sheet) with J3 = 1st sort order, J4 = 2nd sort order, etc. (6 sorting orders currently for formatting reasons, although not sure if we'd ever use more than 3 at a time)
Is there a way to get it to sort the data on the "source" sheet by applying the sorting order manually/dynamically by selecting the order from a drop-down list?
Sorting Order | |
1. | Type |
2. | Sale Date |
3. | $ PSF |
4. | Square Feet |
5. | Year Built |
6. | Beds |
Hope I explained it well/clearly enough!
Thanks
Edit:
This is what the "source" sheet's column headers look like:
web-scraper-order | web-scraper-start-url | Listings | Listings-href | Sale Date | Sale Price | Beds | Baths | Square Feet | Type | Year Built |