Automate Excel Data Formatting and basic coding also typing skill -- 2
Budget: $250 – $750 USD
Open
Posted (see samples first)
I’m working with several Excel workbooks that hold mixed data—text, numbers, the occasional date—and they all need to look the same before I can move on to analysis. I’d like you to combine careful data entry with a bit of smart coding to make that happen.
• Build a small, reusable script or macro—Python with pandas / open, or native Excel VBA, whichever you prefer—that:
– re-orders and renames columns to match my template,
– normalises number, text, and date formats,
Posted (see samples first)
I’m working with several Excel workbooks that hold mixed data—text, numbers, the occasional date—and they all need to look the same before I can move on to analysis. I’d like you to combine careful data entry with a bit of smart coding to make that happen.
• Build a small, reusable script or macro—Python with pandas / open, or native Excel VBA, whichever you prefer—that:
– re-orders and renames columns to match my template,
– normalises number, text, and date formats,
Related categories:
Copywriting
Data Entry
Excel
Ghostwriting
Book Writing
Copy Typing
Content Writing
Typing