Experience Level: Intermediate
We have data files with the data formatted in blocks of data horizontally, that require a lookup table to filter and see specific data entries. We need a macro/script to automatically format these data files in the format we want (super simple, we just need individual columns for each variable!). I think potentially it is pivot tables, but could be wrong. Then to just apply a few formulas and create some new columns. So then we can apply this to the 100+ data files we need to process. Can give much more info to the person who gets the job. It shouldnt take much more than a few hours for an expert. However we do need it within the next 24/36 hours.... Thank you.
Ryan K.100% (1)
29 Apr 2018
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Can you provide sample file?