In total nearly 40.000 records need to be cleaned. A test file of 500 will be delivered.
We have 3 columns in a csv 1. List of current SKUS 2. List of old SKUS 3. Suppliers that are attached to the old SKUS The order of column 1 cannot change. We need to match column 3 values to column 1 and have a list of "new SKUS" with a list of the suppliers next to it. So we are trying to get the list of suppliers attached to the new SKUs (column
improve a 4-column lift on the inventor and perform calculations for material strength, choice of engine and 2D plans of parts. I have a large part of the 3D project, it only needs a modification on the engine.
I am looking for someone to write a Macro. The macro will do the following: Take 2 excel files as input, able to select 2 columns, it will compare those 2 columns and output a new workbook/worksheet where it provides all the rows where the column values matched and another workbook/worksheet where the column vales did not match.
I have a mysql database with a table When user selects row they want to display the table then displays the specific columns in that row on a datagridview. C++ Visual studio Mysql
I have a csv feeed, where i want to fill 3 columns with results from related records where id=id. Attached file for u to check.
Really fast CSV fix for an intermediate to expert file manipulator. All 200+ contacts are in Column A and have multi-fields that need to be placed in columns B-G All uniformly named and this is 5 to 10 mins for the right person. I can show you the file
...Dropdown selections will be a row in the first column in each data sheet, which outputs the rest of the columns. All the columns in each sheet have the same headings in the same order, with different number values per row. The last column will consist of text. Once a selection is made in a drop down box, the data in the data sheet is outputted into the Results
I have an excel file with 384 input columns and approximately 86000 data point. each row represents 1 second. I want you to write a macro that would take each column copies it and provides an adjacent column with 5, 10, 15, and 20 seconds delays. Simply the column gets copied, inserted next to the original one and the data is shifted down 5, 10, 15
I have a XML file that needed to be parsed. From the file I need to retrieve specific field values and create text or xml document. I am will provide the XML file once project get awarded. Feel free to ask further question to clarify .
I have some work, in an Excel spreadsheet.
An Excel spreadsheet on an iphon...spreadsheet on an iphone is being further developed and assistance with coding for two columns is requested. IMPORTANT: Due to the limitations of Excel running on an Apple Iphone environment no VBA code can be used. The two columns to be coded draw on the surrounding columns to decide what data populates each cell.
I need to change the dolibarr mailing to add "contacts by third-agent" and/or to add "contacts by third-postal code" and I have just upgrade the version to 7.0.1 from 4.0.0 and ALSO with the upgrade of the older works, that now they do NOT work with the new Dolibarr... TO-DO: 1.-Fix the old works: In the "list of thirds" the column "Poligono" do not show re...
Convert excel with multiple text columns which require parsing into multiple row entries for loading into access or SQL server database. There is a standard delimiter used in all columns of text data. Provide SWL statement for use with future data.
Hello. I have some files with data in cells splitted by semicolon, and I need to unstack them into rows, using first column as identifier. Examples of initial data and what i need to achieve is enclosed I need sources - eg - Excel formula, VBA code or Python code to complete work on own files Budget -10$ - any offers above will be reported
Hey Guys, We have a custom Shopify Theme that we manage for our client and she's requested a modication in relation to shop columns. Going to be very difficult to explain this via written text so I have recorded and narrated a video for you that shows and explains what we are looking to accomplish. Video explaining what we need: [ログインしてURLを表示]