Filtrer

Mes recherches récentes
Filtrer par :
Budget
à
à
à
Type
Compétences
Langues
    État du travail
    556 Concatenate travaux trouvés au tarif de EUR
    Do some Excel Work S'est terminé left

    PLATE FORM - EXCEL Vlookup, Hlookup, Pivot Table, Validation, Formatting, Macro, Len, Trim, Proper, True False, Sum, Count, Count A, Count Blank, Chart, Count if, Clean, Concatenate, Filter, Advance Filter, Custom Filter, Right, left, Upper, Lower, Proper, Convert, Tex To Column, Formatting and more excel functions. TYPING SPEED In English :

    €27 - €223
    €27 - €223
    0 offres

    Hi, Looking for someone to create a VBL / Macro in Excel to download and concatenate all the images from excel hyperlinks to specific folders. Collumn A : Folder Number Collumn B : 1st Picture Link (if only one picture) Collumn C : 1st Picture Link (if 2 pictures) Collumn D : 2nd Picture Link (if 2 pictures) this up to 4 pictures possible Images

    €36 (Avg Bid)
    €36 Offre moyenne
    22 offres

    ...| 2 | old | 4 auto | 2 | bazar | 2 Column5 - I already know the formula, its "=ArrayFormula(transpose(split(rept(concatenate(A3:A5000&char(9)),counta(C3:C5000)),char(9)))&" "&transpose(split(concatenate(rept(C3:C5000&char(9),counta(A3:A5000))),char(9))) )" Column6 - for each combination i need multiplication Column2*Column4

    €9 (Avg Bid)
    €9
    2 propositions

    ...first one. The work to be done in this first step is: - Create the initial project and add jQuery Mobile Theme Roller classes. - Create a Grunt config file that will: concatenate, uglify, minimize - To guarantee you read the proposal, Grove, include this word first thing in your cover letter - The Grunt file will do the above for the CSS, JS and

    €134 (Avg Bid)
    €134 Offre moyenne
    17 offres
    Build me a VBA code S'est terminé left

    ...the columns starting from AC to AF with Row Type 'D' should be compared with one another. If the values are same then paste the result in the respective 'H' Row Type Else concatenate the values present in the 'D' Row Type values and paste it in the respective 'H' Row Type. The goal behind doing this is that I want to make the multiple lines of Row ...

    €35 (Avg Bid)
    €35 Offre moyenne
    28 offres

    I have a Python script that I use to concatenate a bunch of clips in a folder, into a single video. Unfortunately, this script requires that each video have the same: dimensions, frame rates, and audio/video codecs. I would like the script modified to automatically select the optimal ffmpeg options that also reencodes the least number of videos or the

    €12 / hr (Avg Bid)
    €12 / hr Offre moyenne
    22 offres

    ...can see an example formula along with the sample output for a small number of cells in the attached spreadsheet to see it's just a simple & function being used instead of CONCATENATE to take the text in columns B-W and insert them into the cells in column Y based on the formula. When completed, the script or formula you create will produce tens of thousands

    €131 (Avg Bid)
    €131 Offre moyenne
    31 offres
    Excel Expert needed S'est terminé left

    We are Looking for someone expert in [se connecter pour voir l'URL] qualify for this project I will send some of the selected freelancers an excel test to compl...freelancers an excel test to complete in a given time. You can expect in test expect these functions ROUND, SUM, MIN, MAX, AVERAGE, VLOOKUP, Custom Sort (multiple levels). CONCATENATE, IF, Conditional formatting,

    €23 (Avg Bid)
    €23 Offre moyenne
    26 offres

    ...ID=[se connecter pour voir l'URL] AND (important) pdt_Webwidgetlistbox.WidgetID=[se connecter pour voir l'URL] Again, this is only for items in Type=(2,6). For this WidgetType, we will concatenate the values in [se connecter pour voir l'URL] as a comma-delimited list in the pivot fields. All other Types, we will just take the actual pdt_WebWidgetValue.Value. These

    €143 (Avg Bid)
    €143 Offre moyenne
    11 offres

    - PHP concatenate a string and a variable same line - Echo user time instead of server time. - Build an array to validate values

    €21 (Avg Bid)
    €21 Offre moyenne
    12 offres

    - PHP concatenate a string and a variable same line - Echo user time instead of server time.

    €18 (Avg Bid)
    €18 Offre moyenne
    17 offres

    I have a node server project. I need a grunt file to uglify, minified, compress, zipped, concatenate, node server. I have code written ES6 also. so need to make sure after executing the grunt task, the server still works. Note: I will not able to share the code with you. I will share my screen and then you have to do it.

    €30 (Avg Bid)
    €30 Offre moyenne
    5 offres

    In order to build our dashboards, we need to build a google sheet spreadsheet highlighting several data from a raw data export. We must concatenate several close lexical keywords (2 files, one of 238 entries and one of 298 entries), average the numbers related to these keywords, remove the highest and lowest values. This spreadsheet must be easy to

    €115 (Avg Bid)
    €115 Offre moyenne
    10 offres
    Need Form Code S'est terminé left

    ... User will be able to: 1. Select State from Pull-Down list 2. Select City from Pull-Down List 3. Enter text into text box. B. System will concatenate State, City, and Text Field, and display concatenation string into Field 4: C. User can now ‘Copy” concatenated string, and “Paste” it in other Microsoft docs. $15 MAX

    €16 (Avg Bid)
    €16 Offre moyenne
    10 offres

    I have multiple rows which needs concatenation, text transpose to column in excel. There are about 8000 entries in excel which when formatted will convert to 370+ rows after text concatenation, text transpose. It is very simple task, but needs some time. May be 3-4 hrs will finish the job. I want someone to perform the task will 99.9999% accuracy, I will check each and every entry. Max payout $...

    €17 (Avg Bid)
    €17 Offre moyenne
    33 offres

    This is a pretty fast exercise for someone with experience, there are only 5 tables that need to be denormalized. Easy and quick money before Christmas! I need an expert data model engineer to take an existing physical data model documentation and derive new tables in a denormalized format. Please only apply if you have multiple proven experience working in such an exercise. No time waster.

    €21 (Avg Bid)
    €21 Offre moyenne
    3 offres
    Excel formulas for database S'est terminé left

    Is a micro project, i need to consolidate and concatenate some data.

    €20 (Avg Bid)
    €20 Offre moyenne
    23 offres

    Using FFMPEG a Linux server ready program needs to: 1. get video-1 from https and lower the quality to reduce file size 2.a get a image from https and concatenate it to video-x then cut any frames over (n sec) 2.b optimize video-x for file small size Language Options: Bash or Python 2 or 3

    €176 (Avg Bid)
    €176 Offre moyenne
    18 offres

    ...only read one field. However, the current description field doesn't have all the text that I need. I'm trying to pull together about 10 fields from the real estate listing, concatenate them and make it the new description field. My Partner is a software engineer but, he doesn’t have capacity to maintain the website. If our Upworker impresses us, I will

    €157 (Avg Bid)
    €157 Offre moyenne
    14 offres

    I have a data export that contains duplicate rows of data for the same user identified by email addr...column for each set of rows contains one value, include that value in the final/consolidated row. c. If a column for each set of rows has data in multiple rows, concatenate that data using semicolon delimiter for the final/consolidated row.

    €92 (Avg Bid)
    €92 Offre moyenne
    71 offres

    ...be a 'Save for later' option to queue up entries for submission in one go. If the form has a user ID that matches a previous entry, the database and spreadsheet should concatenate that user entry so that trends can be examined for a user over time. Once saved by the admin, the user who submitted the original form will be notified via email and via

    €1757 (Avg Bid)
    €1757 Offre moyenne
    60 offres

    ...tables - with ID and without. With ID we do not need to use the VLOOKUP formulae since this is automaticly in the tool (1), just use: VALUE(TABLE(COLUMN) for numbers and CONCATENATE for text in the formulae. (2) IF there is no ID we use the index function: so use INDEX(TABLE[COLUMN], position*]. * Position is the number (vertical). (3) For summaries

    €104 (Avg Bid)
    €104 Offre moyenne
    18 offres
    excel format S'est terminé left

    python programming to format csv and concatenate csv files

    €80 (Avg Bid)
    €80 Offre moyenne
    11 offres
    Concatenare informazioni S'est terminé left

    Abbiamo una lista di prodotti in excel. Ogni prodotto ha determinate caratteristiche. Ci occorre una descrizione in cui vengono concatenate tutte le informazioni contenute nelle colonne. I prodotti sono circa 6000 ma se il lavoro di concatenamente viene fatto bene, la stessa regola si può applicare a tutti i prodotti indistintamente. Vedi in allegato

    €22 (Avg Bid)
    €22 Offre moyenne
    6 offres

    ...entries that are deposits with multiple financial sources. I need to evaluate the data, the deposits, the trends, and amount paid each month. Here are some of the tasks. 1. Concatenate payer source and bank account number. 2. obtain annual totals by payer source, 3. obtain monthly totals by payer source, 4. calculate and the last twelve months revenue

    €10 / hr (Avg Bid)
    €10 / hr Offre moyenne
    12 offres

    I receive a PDF fle and from it you have to extract all the information to conatenate it in a file in a line and in a specific order prepare it to be imported by vtiger. Are about 25 fields and the pdf sepeats once with and extension at the end. it would supply three o four files pdf and the arder of the fields to be imported by vtiger. The script is for Debian with automatism for cron

    €34 (Avg Bid)
    €34 Offre moyenne
    1 offres

    I have an issue when I upload products to our...products to our woocommerce product db where all the products details upload with exception of the Description and Short Descriptions fields. I think it might be do to a =concatenate formula i use in the field, but not 100% sure... Need someone who's available to work on the solution with me right away.

    €22 (Avg Bid)
    €22 Offre moyenne
    13 offres

    ...update attribute on price quantities and new skus to amazon. I can provide exemple of the data and manipulation that has to be done to each supplier data file but mainly concatenate, percentage addition to cost price, addition of warehouse stock quantities, append a supplier sku designated letter or number. These .csv files can all be downloaded automatically

    €101 (Avg Bid)
    €101 Offre moyenne
    24 offres

    We're looking for an excel guru - for us to merge data ready for website import using Concatenate and Find & Replace tool. We have 65, 000 rows of data. Job task –Using Concatenate we need to display results of: Jobs, Occupation, Likes&Interest Jobtitle Engagement Percentage| Results should be: Boxing 0.7 46|Clothing 0.7 46| If data is blank – please

    €16 (Avg Bid)
    €16 Offre moyenne
    22 offres

    ...6) Cell referencing: Relative & Absolute 7) Crash Course on Functions & Arguments with Examples - Basics (e.g. SUM, AVERAGE, VLOOKUP, MATCH, INDEX, TODAY, MONTH, LEN, CONCATENATE, IF, AND, CELL, ISNUMBER) - Advanced from all categories ie. - Financial - Date & Time - Math & Trig - Statistical - Lookup & Reference - Database - Text - Logical - Information

    €19 - €160
    Scellé
    €19 - €160
    9 offres

    ...6) Cell referencing: Relative & Absolute 7) Crash Course on Functions & Arguments with Examples - Basics (e.g. SUM, AVERAGE, VLOOKUP, MATCH, INDEX, TODAY, MONTH, LEN, CONCATENATE, IF, AND, CELL, ISNUMBER) - Advanced from all categories ie. - Financial - Date & Time - Math & Trig - Statistical - Lookup & Reference - Database - Text - Logical - Information

    €446 (Avg Bid)
    €446 Offre moyenne
    14 offres
    Excel Formula Help S'est terminé left

    Need a formula to display yesterday's date in this format: date_shipped:2018-8-31 date_shipped:",CONCATENATE(YEAR(TODAY()),"-",MONTH(TODAY()),"-",DAY(TODAY()-1))," I use this Excel formula to get yesterday's date for our tracking numbers. I need to show that the date shipped was Yesterday. For ex. Today is Aug 1, 2018. The formula needs to show

    €21 (Avg Bid)
    €21 Offre moyenne
    17 offres

    Help with qliksense. Data model. Very simple model where I have date dimension in more than 1 fact table. I have circular reference or synthetic key however I try. I need concatenate or join or link table I think in qliksense. It runs off SQL views. I have good database background and am stuck in relational mindset. It's holding me up on a project at

    €12 / hr (Avg Bid)
    €12 / hr Offre moyenne
    1 offres

    ...users create long-form animations up to 3minutes by joining individual animation types/slides together. Here are the individual slides that users will be able to edit and concatenate into longer animations. [se connecter pour voir l'URL] the editor should be able to export animations to JSON object. should also be able to import/open JSON to

    €518 (Avg Bid)
    €518 Offre moyenne
    11 offres
    Do some data entry S'est terminé left

    I have some work, in an Excel spreadsheet. Pivot, vlookup, hlookup, concatenate, text to columns, conditional formatting, if else

    €19 (Avg Bid)
    €19 Offre moyenne
    31 offres

    ...finance statement) • Macroeconomics ratios (GDP, CPI, Job, Interest rate, …) • Sentiment data (Google news, Social networks) Part 2: Data Preprocessing • Dummy variables • Concatenate data frames • Missing data • Scaling data • Feature processing using ensemble feature selection o Increase the dimension o Reduce the dimension o Avoid over...

    €570 (Avg Bid)
    €570 Offre moyenne
    26 offres
    EXCEL VBA MACRO S'est terminé left

    ...some of the rows, The macro should loop through the spreadsheet and copy the content of column A to column B (to the end of the string in column A) 1. Please do not use concatenate, i would need an alternative solution. 2. Macro needs to be quick, the spreadsheet can have 100K+ rows 3. Please put in the code with a quick explanation as to what it does

    €20 (Avg Bid)
    €20 Offre moyenne
    69 offres

    ...In source 1 and source 2 – find duplicates (and possible duplicates where unique records are very similar but may have small variation on one field. Ie: you will need to concatenate or use a similar method to identify close matches) 2) Compare source 1 against source 2 – identify unique records in each (2 way comparison) 3) Compare source 1 and 2 against

    €104 (Avg Bid)
    €104 Offre moyenne
    10 offres

    2nd step is bringing different features of my choice or create a new feature based off of their features evaluated. 2nd part will bring the wh...prediction. In conclusion creating a tool that will find some type of common motif, patterns, and features. So Basically compare and contrast old features Or we can concatenate/combine old & New features

    €451 (Avg Bid)
    €451 Offre moyenne
    10 offres

    Two input csv files. One desired output csv file. The required actions are easily performed in Excel (add and delete columns, concatenate, match rows between two files etc.), but I would like to obtain a program that can be run from command prompt/shell to automate this process. A script in any common language is ok: C, Perl, Python etc. NOT looking

    €115 (Avg Bid)
    €115 Offre moyenne
    10 offres
    Data Cleaning S'est terminé left

    I have about 662,000 rows of data. They are text data, and some are not in English. First, I need those non-English ones to be translated to English. And then, concatenate all of the text data together, seperating each observation by , The output needs to be imported in R. So for example, if there are three rows of text data, the output will look like:

    €137 (Avg Bid)
    €137 Offre moyenne
    49 offres

    Code in VB .NET to concatenate the attached two CSV files (with spanish accents) in one Excel file with the same accent.

    €102 (Avg Bid)
    €102 Offre moyenne
    50 offres

    I have the python script file_creator.py. That script has on purpose to take over 1037 CSV files and concatenate them into one single file. The problem with it is each time I run the script, my whole system freeze. How could I prevent my CPU from reaching 100%? I have that problem with many other scripts and I just don't know how to prevent that problem

    €18 (Avg Bid)
    €18 Offre moyenne
    17 offres

    ...Currently we use excel but it is easy to make mistakes and I believe a database form will simplify this and prevent accidental mistakes. The excel file uses a lot of the Concatenate Function to generate the csv format but I'm not sure how Microsoft Access will use this function or do this task. Good knowledge of Excel functions and MS Access is required

    €161 (Avg Bid)
    €161 Offre moyenne
    52 offres
    I need an Excel Expert S'est terminé left

    On the Properties worksheet, in cell J2, use the CONCATENATE function to display the city in cell C2, followed by a comma and space, followed by the state in cell D2. Fill the formula down through cell L38. AutoFit column J. On the Properties worksheet, copy the range J2:J15. Display the Region 1 worksheet and paste the values in cell D3 using Paste

    €59 (Avg Bid)
    €59 Offre moyenne
    7 offres

    I need a Macro that can Concatenate each cell of a column with every cell from a different column Example ColumA ColumnB Column Needed: A 12 A12 G 25 A25 H 66 A66 K

    €20 (Avg Bid)
    €20 Offre moyenne
    12 offres

    I have the following spreadsheet populated with products exported from Magento. [se connecter pour voir l'URL] Some products have more than one image (column “_media_image”). In the case when a product has more than one image, the extra images is inputted on row below, each on its separate row. [se connecter pour voir l'URL] I need these links concatenated with ; and t...

    €23 (Avg Bid)
    €23 Offre moyenne
    26 offres
    Excel Program S'est terminé left

    I need A VBA or other program, that would process an exce...e.g. Change everything in column 2 and 3 to Proper form. Replace certain words with pre-selected words in certain columns. apply certain formulas to fixed columns, e.g. concatenate for date change e.g. converting a year e.g. 2001 into [se connecter pour voir l'URL] format. This must all happen automatically.

    €21 (Avg Bid)
    €21 Offre moyenne
    30 offres

    ...latest, Firefox latest, Safari latest, IE11, MS Edge latest) and iOS / Android latest). Ideally you are developing it with well structured SCSS / Sass and Gulp to minify / concatenate CSS and JavaScript. I am a German webdeveloper with my own company and have lots of WordPress project to follow up if this one runs great and to my complete satisfaction

    €479 (Avg Bid)
    €479 Offre moyenne
    109 offres

    We have saved multiple data of our customers in database on our server. Have to fetch their name, add (concatenate) a variable to name and sync/store contact on a phone (read as multiple phone numbers) Have to provide a button on UI. Duplication not to be done.

    €24 (Avg Bid)
    €24 Offre moyenne
    13 offres

    Meilleurs articles de la communauté Concatenate