...data as a separate column. For example, the first folder contains data for a company called 2 K WEB GROUP, its comments data should be appended with other comments data in other folders, so should fullstats and statsperday data. And 2 K WEB GROUP needs to be the first column of the appended data. Final outcome will be three Excel files: comments_all
...upload to our domain by using our shopify login credentials. how we do now is, we download the xml file and open it over excel or google spreadsheet and edit the file, transform in to csv file with the added information and change column names and add extra columns before upload than transform in to csv file and upload to our shopify store. every other
I need a C # script to import two excel spreadsheets (Template 1 and Template 2 attached) into an Azure SQL Server. This script should do the same as the OPENROWSET command does. All rows and columns must be imported without any processing. There will be two milestone payments. Half when the script is delivered and half at the end of the validation
I have very rough outline in excel as to some of the initial tables, indexes as well as an excel file laying out how the tables relate to one another. Some of the functions of the interface/database listed below. Requirements of front end/back end: Will run the sql dB and front end on an in house sql / web server with the ability in the future to
I have a excel file of some customer data I need cleaned up. I want to remove everything except the first name, last name and email address. I want three columns of data, First Column is the email address, second is the first name, and the third column is last name. No other data please.
Original project is here https://www.freelancer.com/projects/c-sharp-programming/FULL-STA...will return our reports. Output of the results should be online to the screen and have the option to export to pre-formated excel spreadsheet. We will give an exemple so that you know how to make the layout (filters and column formating).[login to view URL]
...see if there is anyone who will be able to assist me with creating a VBA excel add in that I am able to push data from an excel to a google spreadsheet and vice versa pull data from an google spreadsheet back to excel. I want to have my colleagues be able to update through excel and if I am on the go make changes through google sheets and sync. I know
I have one (1) Excel spreadsheet with contact data in a single column (column A). I need to convert both of them into multiple columns (NAME, TITLE, COMPANY, TENURE, LOCATION). There are approx. 6000 rows in the spreadsheet and approximately 400 total contacts. The first two rows have been completed in the spreadsheet as an example. It's highlighted
Hi We have a small scraping macro written in VBA which takes [login to view URL] game ID from column D and scrapes data to Excel for respective cells (so for example for ID 1402510 it will scrape data from [login to view URL]) However there are some minor issues with this macro. One of them is scraping data when betting market was
I need an Excel script (exe) that allow me to add to the second column the name of the file and to the third column the name of the folder in wich the file is. For example: 1 - I have a folder named "main_folder". 2 - This folder contains 900 files .csv named: file1, file2, file3.....file900 3 - The first column of each .csv file has a variable number
...clear definition of a variable, you need to pick up the data cells for further graphing and analysis. You can do cell selection inside R. Or to make it simpler, you can use Excel to select the data cells about the variable, and save them to a new csv file, and read the file into R later. Either method is ok for the assignment. 3. Some failed to get
...have an excel spreadsheet with about 650k rows. Column B contains dates that are not currently interpretable by Excel to be in a “date format”. Therefore, I can not manipulate the dates to use in excel macros and formulas because excel is not recognizing them as dates to begin with. I need someone to convert the txt based information in colum...
...working on a personal project where i have an excel sheet (call it input sheet) with 4 columns and several rows (not fixed). I need a program which on click can sort out rows in desired order (based on a key word in second column e.g. 'Design', Test', 'Material' etc. and desired format. Results shall be in new excel sheet (call it output sheet). Out...
<Phrase1> - Repetitive data entry from Microsoft Word to Microsoft Excel, all data will be serialized before provided. Template in Microsoft Word will be provided for all documents required, please suggest any changes that you deemed as an improvement. - Associating single-column updates according to serial number /name /address to the respective row(s)
...fill blank spaces with the true value. I am including an Excel file with two worksheets. On Worksheet 1 you will find the report that should be fixed. On Worksheet 2 you will find the table where you should look for the ID Number (Column H) of the row and find the true value for the column that is blank (highlighted in yellow in worksheet 1). *Please
Ok team, please view attached the excel costing sheet. Once read the description and looked through the file please when you submit your bid tell me briefly how much you can reduce the amount of entry’s. Only then will I consider the bid, if it is automatic proposal then I will not look at it. What I would like from you my friends; 1: Rebuild
We are looking for a Freelancer to transcribe our PDF document to Excel. You will be extracting item pricing data. We need the following for each item. If the item does not have one of these, use "N/A" for the Excel column: - Item ID - Case Pack - Title - Price In total this PDF is 40 pages. Please send your quote for 40 pages.
I would like to hire someone who can export all data from a website (front end) into an Excel worksheet. The website is [login to view URL] I want the data to be in columns, a flat list including all information (each in a column) and categories.