Oct 24 2020 11:38 AM
Oct 24 2020 12:01 PM
Oct 24 2020 12:29 PM
Power Query could work. If you have one table with column headers as A, B, C (table could be empty one, only headers) and append to it table with headers as C, A, B, resulting data will be placed as A, B, C
Oct 25 2020 12:00 AM - edited Oct 25 2020 12:04 AM
@Sergei Baklan
Thank you for your prompt and valuable reply. Basically I am preparing a template for my team for filing monthly tax returns. We will get monthly data sheets only after the end of the month. We get the data sheets with more than 100 columns that too in un-arranged manner ( As client software has different logic for exporting the data into excel ). Even in the data sheet we receive from our client my have new columns or may not have all the columns which we may have in our finalized format.
In a current position , my team is to copying data from one column to the desired final columns , and here there is a chance of pasting data under wrong column. So to avoid such error , I want some solution , where my just had to browse the file in to finalized format , data from un-arranged workbook , will be automatically shifted at right column. Any additional column should be added at the last and if any column was not available in a particular month then , in finalized format , for that particular month , that column should remain blank.
To explain this with format , I have attached 4 Files.
1. Finalized Format - My desired output after importing data for 3 months
2. 3 months data files - All the 3 workbooks have un-arranged columns.
I have tried , power query , but may being new to excel ( not pro like you sir ) , i didn't worked for me. As I didn't understood how to give column reference.
Once again thanks a bunch for sparing time for me and replying to my queries. Good day. Take care.
Varsit N. Shah
Oct 25 2020 12:03 AM - edited Oct 25 2020 12:18 AM
Thank you for your prompt and valuable reply. Basically I am preparing a template for my team for filing monthly tax returns. We will get monthly data sheets only after the end of the month. We get the data sheets with more than 100 columns that too in un-arranged manner ( As client software has different logic for exporting the data into excel ). Even in the data sheet we receive from our client my have new columns or may not have all the columns which we may have in our finalized format.
In a current position , my team is copying data from one column to the desired final columns , and here there is a chance of pasting data under wrong column. So to avoid such error , I want some solution , where my team just had to browse the file in to finalized format , data from un-arranged workbook , will be automatically shifted at right column. Any additional column should be added at the end of the data and if any column was not available in a particular month then , in finalized format , for that particular month , that column should remain blank.
To explain this with format , I have attached 4 Files.
1. Finalized Format - My desired output after importing data for 3 months
2. 3 months data files - All the 3 workbooks have un-arranged columns.
I have tried , power query , but being new to excel ( not pro like you sir ) , i didn't worked for me. As I didn't understood how to give column reference.
Once again thanks a bunch for sparing time for me and replying to my queries. Good day. Take care.
Varsit N. Shah