Excel Data Structuring: Dates, Descriptions, & Amounts
Budget: $10 – $30 USD
I have a mixed-data Excel file currently organized in a single column. The data is partially structured but predominantly scattered. My goal is to have the data neatly organized into three distinct columns: dates, descriptions, and amounts.
Key requirements:
- You should have a good understanding of Excel and its functions.
- You must be able to interpret and manipulate mixed data types.
- Experience in data cleaning and structuring is highly desirable.
- Attention to detail is crucial as the dates are in a non-standard format.
- Ability to provide a clear, structured output from initially random data.
Ultimately, I need this project to result in a tidy, useful Excel file that I can use for further analysis.
Key requirements:
- You should have a good understanding of Excel and its functions.
- You must be able to interpret and manipulate mixed data types.
- Experience in data cleaning and structuring is highly desirable.
- Attention to detail is crucial as the dates are in a non-standard format.
- Ability to provide a clear, structured output from initially random data.
Ultimately, I need this project to result in a tidy, useful Excel file that I can use for further analysis.