I have excel worksheets (csv format) from different clients, where first row of all worksheets contain the column names. However, the order and number of columns in each worksheet can be different. Let me give a minimal example:
cpu, memory, disk, printer xxx, xxxxxx, xxxx, xxxxxxx
network, cpu, memory, mouse yyyyyyy, yyy, yyyyyy, yyyyy
So I want worksheets A* and B* such that they only retain the columns that are common in both A and B. So in effect an intersection of A and B with respect to the column names while keeping the previous values.
cpu, memory xxx, xxxxxx
memory, cpu yyyyyy, yyy
Any ideas on how to accomplish this in Excel? Any help or pointers will be highly appreciated :)