Jul 24 2019 06:53 AM
Hi All,
Please accept my apologies if there is a similar request asked already, or if this is a profoundly stupid question, any help would be greatly received.
I have two large data sets.
1 is all of the property sales in an area,
2 is all the properties epc ratings by area showing square footage, energy usage etc.
I want to merge the two data sets into one large table so that I can chart the information.
The only common denominator between the two data sets is the address of the property.
What would the formula be to use the spreadsheet 1 (Sold price data) as my base, and add all of the information to it from spreadsheet 2 (EPC Data)?
I would like all the data from spreadsheet 2 added to each line of spreadsheet 1. I guess I need a formula to look up and make sure each full address and post code matches (they are in separate columns), and then add each field from spreadsheet 2 over to spreadsheet 1?
I have attached an example file to show the two data types I have although they will not match as I have taken 10 lines or so from millions of lines of data.
Thanks in advance
Jul 24 2019 07:01 AM
Jul 24 2019 07:12 AM
Apologies and agreed.
I have uploaded the file again with column headers.
Thank you for looking at this for me.
Regards,
Jul 24 2019 08:10 AM
Jul 26 2019 03:25 AM
Thank you so much! I will be trying this over the weekend and see what results we get. :)