Quote Originally Posted by SamT View Post
Those are common problems. The issue with your request is that only those tables listed in my previous post have two common columns. Having at least two common columns is a requirement for combining tables.



That would be the same as manually pasting each table, one below the other, (In proper column order,) then sorting the new table on Regno. You wind windup with a series of Stair stepped rows, with each table's entries below and to the right of the previous table, for each regno.

We know that you have the raw data converted to CSV files, We have see the impressive amount of wrok you have already done with that data, We are very sorry that that work was for naught.

I do not believe that one big table is your ulitmate goal. You have never told us what you ultimately want to do with the data.

Please tell us the ultimate goal, let us see the CSV files, and let us recommend a way to reach your ultimate goal.

NOTE: If you let us see the CSV Files, only share the top 5 (Five) lines in each. That is all we need to see. Some of us are already limited to the first 65K lines.
My ultimate goal to analyse the data as well as open source the information. I want it collected into one table so the information can be easily compared and related to each charity/regno number.

Here are the filtered files (data only for class ref=110). You can just rename the extensions to .csv: https://my.pcloud.com/publink/show?c...jsyxBeRyDpG6CV

Do you also need the original data (for all class refs)?