Import or copy columns to another workbook in a different order
I am trying to import an Excel file with headers A1, B1, C1, D1, A2, B2, C2, D2, A3, B3, ...D4. Each of the headers has data for 150 rows. I have to import this data set to another workbook but in the order: A1, A2, A3, A4, B1, B2, B3, B4,....D4.