I'm looking to merge CSVs that have common columns, but the columns aren't always necessarily in the same place. The CSVs do have a header row. I just want to try to get the data appended to the bottom. For example, each CSV will have the column "Name,""Favorite Color," and "Lucky Number." Some CSVs will also contain other columns, such as "Favorite Animal." Also, "Name" may not be in the same spot on every CSV. Note: the end goal here is for me to be able to do a pivot chart with the data. I know (or I think) that Excel can make a pivot table/chart from multiple worksheets -- but I'm not sure it can handle 52 worksheets that are plagued by the problems I mentioned above. Any thoughts? Note -- I think I could probably get this to work with Google App Script, but the resulting spreadsheet would be too big for Google Spreadsheets to handle.
Here's some examples of what I'm saying... https://gist.github.com/anonymous/4948945