Hi All,
I had a quick question on data sorting that I hoped you could help with.
I extract data from a system on a daily basis and copy and paste it into a master spreadsheet, so its one long continuous list of data. However the system I get it from often changes the order and adds columns which puts the data in different orders, but the header names remain the same.
Is there a good technique for importing or appending the data so it pulls through the set columns without too much manual intervention?
I had a quick question on data sorting that I hoped you could help with.
I extract data from a system on a daily basis and copy and paste it into a master spreadsheet, so its one long continuous list of data. However the system I get it from often changes the order and adds columns which puts the data in different orders, but the header names remain the same.
Is there a good technique for importing or appending the data so it pulls through the set columns without too much manual intervention?