Hi Team,
I have data from HR coming with different order for columns but the same column name. Every time I receive an excel file, they put in different order but the numbers of columns and name of columns are the same.
Due to confidentiality and access issue, I am not given access to the database directly. Instead one of the administrator from HR is sending me the different order file.
I was required to do only excel dashboard report based on these data. Please let me know the best way to clean up those different order columns.
Thank you.
Please see an example attached. It is only an example and I have more than 100 columns with different order every time.
Regards,
Aye
Hi Aye,
I would go back to HR and insist on them providing you with a file with the columns in the same order every time. They should create a query view that they simply re-run when you require it. If they're building the report from scratch each time then they're wasting a load of time.
Mynda
Thanks for your advise, Mynda,
I will check with HR.
Regards,
Aye
