Welcome to my gig. I am offering high-level data manipulation services in Microsoft Excel/spreadsheets.
Note: Please contact me prior to ordering to avoid cancellations. I'll get back to you asap.
The highlight of my services are:
- Merging multiple spreadsheets based on matching key values.
- Combine multiple spreadsheets. The data from columns with same name will be joined even the order of columns is different.
- Merge duplicate rows and aggregate their unique data
- Consolidate worksheets (sum the values of matching labels)
- Copy dozens of sheets in one workbook.
- Compare two spreadsheets to find duplicates and unique values. Separate the values existing in both sheets and so on.
- Identify and highlight duplicate values. Duplicate removal and deleting.
- Remove leading and trailing whitespace. Similarly, reduce spaces between words to 1 space.
- Copy paste filtered values
- Add specific value to specific/custom point such as at the beginning, at the end, before some text, after some particular text, after the first 3 characters and so on
- Extract characters based on location (first 4, last 3 etc), based on character
- Delete characters based on location etc