Column splitter jqgrid jobber

I'm looking for a skilled Python developer to create an Ant Colony Optimization (ACO) algorithm that can read numbers in a matrix to calculate the shortest distance and its respective cost. Key Features: - The algorithm should respect origin and destination points, which will be indicated by specific row and column numbers. - Ideally, the code should be able to parse a .xlsx file format. Desired Skills: - Proficiency in Python programming language - Experience with optimization algorithms, particularly the Ant Colony Optimization algorithm. - Familiarity with .xlsx file parsing. I already have a basic code and can provide it to you as reference material; however, I need someone to improve and expand on this code to meet the requirements. It is essential for the proposed so...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient i...query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Ex...

...going to be separate for all pages. The header is supposed to be a branch of a tree with the sitelogo on it in the middle. - On a desktop view we want the left side of the screen to have a tree trunk run along on the left till the footer And leaves on the right. - Footer content should include: Column 1: Small kalataru logo and under it social media links Column 2: About us Contact us Careers Kalataru Magazine Column 3: FAQs Returns and exchanges Shipping and Handling Terms of Service Privacy Policy Column 4: Sign up to our email Newsletter (Email ID text box with validation) (Subscribe button) - Integration with payment gateway (phonepe) - Cart and login mechanism should be OTP based and very direct and easy - Collect user data in a proper format (ip, usage...

I need to manually add text and picture annotations to a PDF document . I have a pdf document but pictures do not show up some places in the document, I have the pictures and need someone to have two columns with the original on the left and add the pictures in a second column on the right of the original document where they should have been inserted . there are about 15 photos that need to be matched up . should not be more than 2 hours . also there are 8 names that need to be inserted wherever they show up in the document .

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Prof...query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Ex...

...cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this? Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively. The 5 different grading options are: Not yet started Not yet submitted Submitted for marking Partially Complete - More work to submit Competent Each cell and submissio...

I need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel format:

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - E...

I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.

I am looking for an expert in website speed optimization to improve the mobile page speed of my website. The main goal is to enhance user engagement. I believe an improved page speed will keep my visitors on the site longer, resulting in more interaction. Additionally, I need my blog pages laid out in a single column format. This should be optimized to ensure a seamless user experience across multiple devices. While there are no specific responsive elements advised on, the developer should ensure general responsiveness throughout the page, including any present text content, images, or embedded videos. Ideal Skills: - Proficiency in website speed optimization - Experience with responsive website design - Expertise in blog layout design Experience in SEO will be an added advanta...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbo...data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book o...

Change label name Change the id format of the field( one column only) Link the column with correct table. Only developer who can go one by one (I don't share all)

Google sheet has 5 columns. From the user interface you have to select 4 choices from left to right via drop-down boxes. Once the choices have been made, which must lead to the selection (if possible) of one or more choices, the final result selected in the fourth column must print in the user interface, the contents of the fourth and fifth columns (the latter is a link) . The interface must have a background color, a text with a provided font, and two small images.

...Match-3 Puzzle Mechanics - Experience with Dog-Themed Games Please provide examples of similar games you've developed in the past. game requirements include but are not limited to: The game should be based on the idea of Candy Crush, however, using a dogs theme Gameplay: - Match-3 Mechanics: The core gameplay revolves around matching three or more dog treats of the same color and shape in a row or column. Players can swap adjacent treats to create matches. - Objectives: Each level in has specific objectives that players must complete to progress. Objectives may include reaching a target score, clearing a certain number of treats, or achieving a special pattern on the game board. - Obstacles: As players progress through the game, they encounter various obstacles that add c...

I have a big PDF and website data that I need to consolidate into a single Exce...to make this work. Key Points: - The data is spread across a large PDF and a website, and I need it all extracted and combined into a single Excel spreadsheet. - I need product decision, finish, list price, cast Qty, Master Qty, weight, length, and similar details extracted from both sources. - The extracted data should be organized in the Excel spreadsheet with each data point in a separate column. Ideal Skills and Experience: - Proficiency in data extraction and consolidation from PDFs and websites. - Experience in Excel and its advanced functions to organize data efficiently. - Strong analytical skills to help with product decision-making. - Prior experience in similar projects would be a bonus. ...

I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.

I'm seeking an experienced web developer with a firm understanding of SEO and WooCommerce to create an optimized wholesale jewellery website. The website needs to be single-column layout and possess user-friendly features to provide the utmost convenience to our customers and drive our online sales. Key Features: - Product search functionality - Product filtering options - Wishlist feature - Price display for authorized users only - Barcode capability - Comprehensive reports - User-friendly payment integration via direct bank transfer The website is expected to host more than 500 products, and the platform needs to be effortless to navigate and manage. The ideal candidate should have a strong background in eCommerce websites and superior knowledge of WooCommerce. Experience ...

... This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro allows to: • Generate the Output in a separate spreadsheet (which captures only the required fields and re-arrange them) • Optional: Enable the Save function (allowing to define the saving location). o Default the Saved name as: (Allowing me to select the saving location). Important: The

...(Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslation) !!! Please: Can you confirm or clarify your offer better? ...how many days do you need ? ...what kind of trace/flow do you think ? *all my easy action, now start from === old asset - new asset; Aruba / Italia ...next to Hostinger / Lituania

Seeking a CSS specialist who can customise my existing Paperform, enhancing its visual appeal and functionality. Key tasks include: • Changing the background color for improved readability and aesthetic. • Refining font style for better clarity and appeal. • Modifying the button design to make it more engaging and user-friendly. • Aligning the form fields in a 2 column grid layout for better user navigation. • Adjusting the overall design and layout to create a visually-pleasing and easy-to-use form. Ideal candidate should have significant CSS experience and a strong understanding of form design principles for maximum user engagement and response rate. A knack for detail, design, and delivering rapidly is advantageous. Let's make this form as user-fr...

I am in need of a Google Sheets expert that can help me in matching multiple columns using exact match criteria. The primary aim is to integrate data accurately. Ideal skills required for this task are: - In-depth knowledge of Google Sheets. - Experience in data cleaning, manipulation and integration. - Proficiency in managing large datasets. - Good understanding of exact matching techniques. Your main responsibility will be to: - Find exact matches between columns in a Google Sheets spreadsheet. - Deliver an integrated dataset with correctly matched columns. - Ensure data accuracy and integrity post-integration. Movies you to be fast, meticulous, and skilled. You need to have a proven track record in dealing with similar Google Sheets tasks, and be able to deliver clean and well-in...

...scroll (use this api to get the city data: ). The table should have columns city name, country, timezone etc. Implement search as you type for this table. Utilize an autocomplete feature to suggest possible locations as users type. Implement filter and sorting for each column Clicking on the city name, should take to to the weather page for this city Right clicking on the city name and opening in the new tab should also open the weather page for the city but in the new tab. Weather page: You can reach this page by clicking on the city name in the table section as mentioned in the previous section. Use free api to display weather on this page

I need a multi-column PDF document to be converted into an Excel table. The layout is moderately complex. Here are some additional details: - **Task**: The primary purpose of this conversion is data entry. As such, the Excel table must be an accurate representation of the information in the PDF. - **Layout**: The PDF contains multiple columns of text which need to be correctly mapped to the appropriate cells in the Excel spreadsheet. - **Verification**: After the conversion, manual review and correction are required to ensure that the data has been accurately transcribed. Ideal skills and competencies for this project include: - **Strong attention to detail**: Given the manual verification needed, an eye for detail is crucial. - **Excel proficiency**: A good understanding of Exce...

...video content. The main goal is to differentiate between questions and sentences contained within a video transcription CSV data file. Following features are required: - TF-IDF, LSA, LDA, Word2Vec, and SentenceTransformer for text vectorization. - Utilise various models to evaluate the performance using an ROC curve. - The differentiation of the content type should be indicated in the 'label' column. The value can be 'question' for sentences that are actually questions, and 'sentence' for regular statements. - Development of a RESTful API with Flask. - Dockerization of the API. Ideal candidates for this project should have: - Proficiency in python and libraries used for Natural Language Processing. - Experience in utilizing machine learning mode...

I have a very simple three js project in a website that I want to be worked on. I will supply a google sheet with 8 co-ordinat...website that I want to be worked on. I will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given as (X,Y,Z) The first co ordinate is made up of 3 columns named (1X), (1Y) and (1Z) they have a number in the column for shape 1 you must use those 3 numbers to generate the first co-ordinate. Then repeat for (2X), (2Y) AND (2Z) up to the final cordinate (8X), (8Y) and (8Z). Each shape is given along the same row in the google sheet, and has a hexcode colour. The shape should be filled with the hexcode colour in the hexcode colour column. If new rows are added to the google sheet the three js project should add more shape...

I have a very simple three js project in a website that I want to be worked on. I will supply a google sheet with 8 co-ordinat...website that I want to be worked on. I will supply a google sheet with 8 co-ordinates per shape, the co-ordinates are given as (X,Y,Z) The first co ordinate is made up of 3 columns named (1X), (1Y) and (1Z) they have a number in the column for shape 1 you must use those 3 numbers to generate the first co-ordinate. Then repeat for (2X), (2Y) AND (2Z) up to the final cordinate (8X), (8Y) and (8Z). Each shape is given along the same row in the google sheet, and has a hexcode colour. The shape should be filled with the hexcode colour in the hexcode colour column. If new rows are added to the google sheet the three js project should add more shape...

I'm looking for a seasoned Project Designer with a strong understanding of options to conduct an intensive research. Expertise working on softwares, call center, robocaller and conversational AI outbound calls for call center. The ide... Responsibilities: do research to find the best integration system in terms of cost and services Skills required: - project building or project manager experiences - wide knowledge of APIs - experienced in integrating, implementing or managing projects or research. how its gonna be delivered and cl as finished is if only: - research docs will be delivered as a EXCEL or Powerpoint, it can be column/tables or presentation - research margin of error doesn't exceed 20% - i dont need need data to be pretty and fancy, as long as its not co...

I have two CSV files that I need compared. I need to compare the file 1 and 2 attached. we have to filter the data in the file 1 column C considering only the voice alta, bassa, media. And check if they are in the file 2 column C "sku" with a quantity (column G) >0 The app need to create as output a file with the data in the file 1 column C considering only the voice alta, bassa, media -> column A and in the column B: - if there is in the file 2 column C "sku" with a quantity (column G) >0 yes - if there is not no If you have any questions contact me. Thanks, Regards, Marco

...name: "cola based soda with no sugar"; or "sugarless cola based soda"; or "cola soda, no sugar, fizzy drink"; etc. Combinations are endless. Our bot must identify all these possible descriptions and name the product to how we name it "Diet Coke". Dataset: Attached with dummy products (I'll share the official one after awarding). It's 735 entries two-column dataset where the first column contains the 'company's products names'. The second column contains many different descriptions. For descriptions associated with 'n/a' in the dataset, indicating the absence of a corresponding product in our portfolio. Language: the dataset is in spanish. GUI: final POV most have graphic interface -- not...

...able to automatically select data from a certain type of table. Hence flexibility is essential. Likewise, it should be able to arrange this selected data against particular types of rows. The formula should be customizable to adapt to various row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA are crucial for this project. Proficiency in creating user-friendly interfaces within Excel for ease of customization by the end user wo...

I want to create a form using google forms where: - the answers are exported into google sheets (this is done by default), each answer in a row. - the answers are exported into google sheets, but I want each answer in a new tab, and in a column (instead of in a row). The tab will have one column with the questions, one column with the answers, and one columns where I will make comments. - the answers are exported into google docs, in a chart. (for instance a chart with 3 columns, where the 1st column are the questions, the second the answers, and the third is empty and I will write comments once the answers are there.) Each answer has to be added in a new page at the top.

...for using and customizing the template in popular email marketing platforms, if applicable. Deliverables: -Fully functional HTML template compatible with Outlook. -Documentation or guidelines for using and customizing the template. -Any necessary assets or resources used in the development of the template. Key Requirements: - Design concept: The template should include a mixed single and multi-column layout, as this is my preferred style. - Branding: It's important for the template to incorporate our specific brand colors to maintain consistency across all of our marketing materials. Ideal Skills for the Project: - Experience in HTML template design. - Familiarity with the Outlook environment for optimal display. - Understanding of incorporating branding into layout and ...

Few column is not linked properly. Delete function is not linked properly (function done)

I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales dat...knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each c...

I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills and can assist with this project.

I have a spreadsheet of ~2100 gas stations in the state of New York. The data includes a station ID, last known brand, and street address. For each address, I need you to find the most recent but not past November 2023 (month and year shown in the corner, most should have images in 2023 available) Google Streetview images and save a screenshot of the price advertising sign for each o...screenshot, the filename should be the station id of that station from the spreadsheet. In the spreadsheet, I need you to also log some variables based on the image: if the sign is a digital display, the type of sign according to an attached style reference sheet, etc. NOTE: Some stations have changed brand, so it may be listed as a BP, but could be an Exxon now. This change can be logged in the NOTES c...

Amend table column. (Add/remove) And some issue example: Delete data immediately remove (need to refresh)

...need of a professional who can extract data from my searchable text PDF files and input them into Excel. The PDF files contain complex data layouts, including tables and images. Key Requirements: - Extract and organize the text, tables, and images from the PDF files into Excel - Maintain correct data alignment and structure - Apply basic Excel formatting, such as font styles, cell borders, and column width adjustments You are expected to: - Have experience with PDF to Excel conversions, particularly with complex layouts - Be proficient in handling searchable text PDFs - Demonstrate knowledge in basic Excel formatting techniques I'm looking for a freelancer who can efficiently convert these PDFs into Excel without compromising the data integrity and layout. If you have exp...

...on main page) where I can add notifications of changes to my companies products and new features. The blog page must fit inside the header/footer of the existing site so it is an integrated part of the web site. There will not be many blog entries - two or three a month maybe. Very few entries will have images and most will not need a “read more” button. I want a minimalist 2 column blog page ( one being the sidebar on left side ) looking something like: The main blog page: Will be minimalist like: On the sidebar, I’d like a search button, popular posts, archive and sharing entries on social media. Accessing the Blog Page: The blog page will be accessed in 3 ways: Via a "Latest News" link from the main page footer menu. ...

...name: "cola based soda with no sugar"; or "sugarless cola based soda"; or "cola soda, no sugar, fizzy drink"; etc. Combinations are endless. Our bot must identify all these possible descriptions and name the product to how we name it "Diet Coke". Dataset: Attached with dummy products (I'll share the official one after awarding). It's 735 entries two-column dataset where the first column contains the 'company's products names'. The second column contains many different descriptions. For descriptions associated with 'n/a' in the dataset, indicating the absence of a corresponding product in our portfolio. Language: the dataset is in spanish. GUI: final POV most have graphic interface -- not...

I am in need of someone to construct a power automate flow for a SharePoint Document library. I wish to add a 'last viewed' column, specifically to boost document management. I want this column to display the respective 'username' of the last viewer. Ideal candidates will: - Have experience creating Power Automate flows. - Be familiar with SharePoint Document libraries. - Possess a good understanding of document management strategies. - Know how to capture and display 'username' data in a SharePoint library.

I am looking for a Google App Script specialist to design a dependent dropdown list on Google Sheets. Your responsibility will be coding an application that enables: - Cross-referencing of data through the dropdown list - This feature should specifically be applicable to certain columns only Please make sure to link the dropdown list to column headers labeled 'Customer Name' and 'Project Name'. An ideal freelancer for this role will have experience in working with Google App Scripts and Excel, or other equivalents, and is meticulous and detail-oriented. Proficiency in managing and organizing data is equally important.

...datos: pgsql Error de solicitud de acceso a la base de datos: SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext, date_creation, tms, fk_user_creat, fk_user_modif FROM llx_categorie WHERE rowid = 457 Código de error de solicitud de acceso a la base de datos: DB_ERROR_NOSUCHFIELD Información del error de solicitud de acceso a la base de datos: ERROR: 42703: column "tms" does not existnLINE 1: ...r, fk_soc, visible, type, ref_ext, date_creation, tms, fk_us...n ^nLOCATION: errorMissingColumn, parse_relation.c:3293 We need to solve this issue. The best price and the most expert person will be selected to solve that error....

I need assistance with a very specific task: transposing customer list data from an existing Excel spreadsheet into a business plan. The format should arrange the data in a column arrangement within the business plan document. Specific elements required from the customer list include: - Telephone number - Email - Personal information Ideal candidates for this project should have experience with: - Excel spreadsheets - Business plan designing - Data transfer and organization Let me know if you need any further information to complete this task.

... The ideal person for the job is quick, efficient, and meticulous, with a keen eye for detail. The ability to understand and work efficiently with large datasets is a must. Proficiency in Excel is expected and prior experience with similar projects would be highly advantageous. DETAILED DESCRIPTION OF JOB: On the attached spreadsheet: Remove all of the accounts that are exempt from work comp (column R shows who is exempt) Remove all columns except for Business name, address, city, state zip. Then I want it broken into 4 separate spreadsheets based on Work Comp x-dates. Q1 (Jan, Feb, March), Q2 (April, May, June), Q3 (July, Aug, Sept), Q4 (Oct, Nov, Dec) Be careful when looking at expiration dates, the bond expiration date is on there, but I want these categorized by Work Comp e...

All of a sudden, the slideshow at is showing all of the slides at once, instead of one at a time. So the slideshow is the full width of the site instead of just in the right column. The slideshow should be directly below where it says "Upcoming Events"

I require a professional to write a script for Google Sheets, specifically to make Column E a "write once" column. This column will involve a choice from a dropdown menu. It's essential that once data is entered in this column, it cannot be rewritten. Ideal Skills and Experience: - Proficient in creating Google Sheets Scripts - Expert understanding of coding for writing scripts in google sheets - Experience in writing "write once" scripts Application Requirements: Please include examples of past work, especially those relevant to Google Sheets Scripts manipulation. Show me how you've solved similar challenges in past projects to make a strong case.

As a client, I am in search of a skilled Python developer with experience in XML parsing and handling database operations. I require a Python utility program to parse Talend jobs and determine source and target column details. Key Requirements: * Parse XML files - The Talend mapping file will be supplied in XML format. We're in need of someone fluent with Python's XML parsing libraries. * Extract information - The utility must be able to extract critical information including source and target table columns, as well as source and target databases. * Dynamic Output format - The extracted information must be formatted in CSV or potentially other formats. It should be flexibly designed as we will use this data to load into a database. * Database expertise - An understanding...

I am on the hunt for someone highly skilled using excel. The selected freelancer will process data from a CSV file, apply exact match criteria, then enter these matched results into another CSV file. It...removed or merged. Prior experience in data matching and a strong understanding of CSV files is highly desirable. Please ensure you can: - Handle large CSV files - Apply exact match criteria - Combine values of a column to replicate a formula - 16 columns of data combining to output a pre determined formula - match the formula across entries on another spreadsheet - 800 rows Let's maximize data accuracy and efficiency together. output formula should be as so - a:[‘number of options’]:{option values separated by ‘;’ } then inputted and matched to a...

I need to import data from multiple files that have roughly the same products in them, but it needs to show me in alphabetical order the product name in the first column and the best prices from each client in the next columns (from largest to smallest). Probably i need macros and i can`t figure them out