Forum Discussion
How to Pull data from Un-arranged columns to Arranged columns
In some cases, the translation does not help to understand the problem. It would be a great help, you don't have to readjust everything to see where the problem could be.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
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