Standardize and Merge Excel Sheets

โดย KarnMukesh
Standardize and Merge Excel Sheets

The project is basically about merging 206 excel files into one. Unfortunately, the layout of columns is not always the same. Therefore, they sometimes need to be standardized before (or after) merging. In more detail: I have excel files with FDI statistics for each country in the world, 206 files in total. In each file, there are 4 sheets: Inflows, Outflows, Instock and Outstock. In the end, I need to have only two sheets: one containing the merged information of all the inflow-sheets and one containing all the merged information of the instock-sheets. As a template, I uploaded two original data files for Aruba and Afghanistan and two files with the merged data of these countries. Please refer to those examples for needed information, layout etc. Important notes: The column "FDI to" must be filled in manually. You find the country's name on top of each original sheet. The country's names in column "FDI from" can be copied from the original tables. But you wil

image of username KarnMukesh Flag of India SAMASTIPUR, India

เกี่ยวกับฉัน

Dear Clients, Greetings! We are open to work with you for any kind of opportunity with high-level of proficiency & efficiency. **Committed To Deliver Quality Services Within the Defined Deadline**** We are open to work for any shifts (24x7) Morning, Evening, Night & General according to your time zone. Give me a chance to serve you. Below is the process that we are dealing with: SKILLS: VIRTUAL ASSISTANT, DATA ENTRY, DATA MINING, DATA PROCESSING, DATA ANALYST, COPY TYPING, REAL ESTATE, PDF->WORD, PDF->EXCEL, WEB LISTINGS, WEB SEARCH, WORD PRESS, WORD, EXCEL (Lookup*, SumIF*, CountIF*, index*, PivotTable, PowerPivot, Graph, Dashboard, Conditional Formattings, etc) DATA ENTRY: => All kind of Data Entry (According to the provided instruction/guideline) ***PAST EXPERIENCES WITH EMPLOYER [COMPETENT SOFTWARE PVT LTD (CORELOGIC, US)] FROM AUG 2005 TO APR 2018*** **** EXPERTISE IN REAL ESTATE DATA ENTRY AND RESEARCH TASK **** *****Processed almost 3000+ counties for 30+ States in last 12 years***** DATA PROCUREMENT: => Data Procurement from various Authorities i.e Assessor/Treasure/County Clerk RESEARCH: => PROPERTY RESEARCH => VALUES (MARKET, APPRAISED, ASSESSED) => DELINQUENT TAXES => ALL KIND OF TAXES => MLS (SELL, RENT AND LEASE AGENTS) => BUILDING PERMIT =>MORTGAGE =>DEED =>JUDGMENTAL DOC'S =>TITLE SOLUTION DATA ENTRY: => All kind of Data Entry (According to the provided instruction/guideline) => Mortgage, Deed, Judgmental, Title Solutions, etc according to the provided instruction or by reviewing Online PDF or directly by reviewing County Website. DATA PROCESSING: =>For all kind of Court Cases (like Civil, Probate, Criminal, Small Claims, etc) Experience With Applications Hubspot Jungo(Salesforce) Signnow JotForm Xencall Clickup Netronline Relator Zillow Realquest Salesforce Putty FastPeopleSearch Business Search Manta Yelp Yellow Pages ***Best Regards***

$5 USD/ชม.

88 บทวิจารณ์
5.8

ป้าย