I've a sheet where I paste data from the website, when I paste, it look like this in sheet(Page 1 and Page 2):-

Here Color Code cells represent the data of one plot, like address,price,area and in address there is pincode

I am trying to make it structured like this if you take first two column block in P 1 in above image, I hope now it make some sense:-

• I need to grab the Pincode from address

• Address can be anywhere in columns, and below them will be there selling/renting details, like price, area etc

Don't know how to start, column has multiple property data which I want to structure

Here is the sheet link:- https://docs.google.com/spreadsheets/d/1M9YUR2NEc0IUvpwmzw1diMSMG9ukZw-269Rvg531WqY/edit#gid=0

Any suggestions?