how to maps columns from one spreadsheet to another.
Posted on 2014-02-24
I have worksheet 1 with lot of data in it.
I have worksheet 2 with no data but the same column headers as worksheet 1.
is it possible to map columns from worksheet 1 to worksheet 2 so that data from worksheet 1 goes into the right columns in worksheet 2.
please note that the column headers order is different in both worksheets and i want to copy data from worksheet 1 to worksheet 2 but in the right columns and dynamically.
Not like copy and pasting column by column from worksheet 1 to worksheet 2.