Excel remove blank lines within cell jobs

...will disregard the latter statement). Input: The first line contains two integers n? (2≤n≤100′0002≤?≤100′000) and q? (1≤q≤350′0001≤?≤350′000) — the number of student in the course and the number of gossips you heard. On each of the following q? lines, there are three integers s? (0≤s≤10≤?≤1), a?, b? (0≤a≠b≤n−10≤?≠?≤?−1) representing a gossip. s? being a 0 means the two students are friends, and s? being 1 means they are enemies. The next two integers represent the two students, which are either friends or enemies. output: Firstly, output q? lines. In the i?-th line, output "YES" if the i?-th gossip from the input is coherent with the previous gossips and "NO&quo...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I have a list of 54 URLs, and I need someone to grab 2 images from each of them, convert them to .jpg and save them to a folder named 'Images'. Key Requirements: - G...list of 54 URLs, and I need someone to grab 2 images from each of them, convert them to .jpg and save them to a folder named 'Images'. Key Requirements: - Grab 2 images from each of the 54 provided URLs (all similar to below URL). 108 images in total. - Example URL is - Grab the biggest version of the image from lines 6613 and 6667 of page source code - Convert all grabbed images to .jpg from .webp - Save them to a folder named 'LC Images' - The images should be saved in the original size, with no resizing necessary. - See attached screenshot

I'm looking for a talented video editor capable of making a less than 5-minute video out of multiple videos. Key Tasks: - Remove certain unnecessary parts from my raw footage - Add effective transitions to enhance the viewing experience and emotional tone as well as music The video is supposed to be about our last year in high school - it needs an emotional ambiance with fitting music Ideal freelancer would have: - Ability to work efficiently within a short time frame

I'm in need of an experienced PHP developer to create a comprehensive web-based portal. This pl...be used by customers to interact with our services. Ensure seamless user experience and accessibility. - Employees: Employees should have access to specific tools and information. Develop an interface that is intuitive and geared towards productivity. - Administrators: The administrators should have full control over the content displayed on the portal. They should be able to upload, edit, and remove text and image content. Ideal candidates for this project should have: - Proficient in PHP development - Experience in creating user authentication systems - Strong understanding of CMS development - Prior experience in developing web portals is a big plus Looking forward to seeing ...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

I'm looking for an experienced website designer to develop a minimalist and monochrome portfolio website for me. The purpose of this website primarily is to showcase my work to potential clients. Here are the things that need attention: - Crisp minimalist design: The website should revolve around a minimalist school of design, with extra emphasis on clean lines and ample whitespace. - Monochrome scheme: The colour scheme should strictly stick to monochrome, encapsulating both aesthetic appeal and professional vibe. - Portfolio Showcase: The site should be designed in a way that it effectively displays and highlights my portfolio to visitors. Possessing skills and experience in minimalist and monochrome website design will serve as a plus for any freelancer interested in this pr...

I need an Excel professional to help me clean up my data. Specifically, I'm looking for someone who can assist with text and number formatting. Key tasks include, but are not limited to: - Data cleanup, focusing on text and number formatting - Ensuring the data is well-structured for its intended use - Delivering the formatted data in a different file format than the original Excel file Ideal candidates should have: - Proficiency in Excel and its various functions - Prior experience in data cleanup and formatting - Attention to detail and commitment to quality - Strong communication skills, as you may need to clarify certain aspects of the data. Please deliver the formatted data in a different file format, which will be provided by me.

...process payments. When I bill a client Stripe processes the payment the client makes. Starting in October of 2023 Stripe placed a RESERVES on my account that holds 35% of all payments for 90 days. There reasoning behind this didn't make sense. They said it was because I was high risk for disputes and chargebacks yet I hadn't had any of those for a year. Once I explained my business they would remove the reserve after a couple weeks.. Meanwhile my business came to a halt because that 35% is essential for my business to operate smoothly. the past 6 months they have placed and removed a Reserve on my client payments which has severely disrupted my business operations. I could start jobs, I lost contracts because of that. my business almost went under. This is all...

I'm looking for an experienced Avaya specialist to assist with the configuration of our Avaya Session Border Controller (ASBCE) - specifically, to set up and integrate it with SIP Trunk Provider lines and Avaya IP Office Server Edition. AVAYA IP Office servers are already configured and calls working internally. - The tasks involved are both the installation of the ASBCE and the setup and integration with the SIP Trunk Provider. This requires a comprehensive understanding of both Avaya systems and SIP technology. - The primary goal for this configuration is to achieve a seamless integration between the ASBCE, the SIP Trunk Provider, and our Avaya servers. The focus is on ensuring robust communication and operation between these systems. - Basic training on how to restrict ex...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

...the calculator's functionality. Interface appearance use graphic buttons (this may be the simplest graphic with a color change), the result of the operation can be presented in the form of binary, octal hexadecimal (additional buttons), enter the history button: opening a new window with information about the actions taken since the application was started, showing the actions in the following lines of the list. Project 2. Create a Music MP3 player mobile application in Flutter or in Android Studio that recommends its users the local area popular songs based on their GPS location. Submit the source code and the apk file as Task2.zip. Project 3. Create a Mobile Application for a Cafe Restaurant to receive orders from its Customers. The Application should offer a list of ...

I'm seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet into a visually appeal...

Hello, I need complet the Amazon categories catalogue excel in french

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I am in need of a professional photoshop artist to remove specific elements from the background of my photos. These elements include: - Parking lot - Outhouse - Sign Once removed, these elements need to be seamlessly replaced to match the rest of the nature in the photo. The ultimate goal is to make the edited areas indistinguishable from the rest of the background. The desired resolution for the edited photos should simply match the existing resolution of the original photos. Ideal candidates would have a strong proficiency in photoshop, with particular experience in photo manipulation and retouching. A keen eye for detail and an understanding of natural light and shadow are also advantageous. There are 30 photos total and they are all very similar.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...high-quality leads and get companies to sign up for our referral programme. The ideal freelancer will have a proven track record in designing and executing successful B2B email marketing strategies and will be able to provide evidence of past performance. Responsibilities: - Develop and execute a comprehensive cold email campaign strategy using Mailchimp. - Craft compelling email content and subject lines designed to capture the attention of potential business clients. - Segment and manage the email list to ensure maximum engagement and response rates. - Monitor and analyse campaign performance, providing regular reports on key metrics such as open rates, click-through rates, and conversion rates. - Optimise the campaign based on performance data to achieve the best possible res...

I require an efficient programmer equipped with the crucial skills in Pine Editor coding. The project involves designing a script based on the 'Trading View' platform to automate my stock market trading strategy. The strategy revolves around Multiple EMA (Exponential Moving Average) crossing. For this specific task, a system with three different EMA lines is preferred. Ideal Skills & Experience: - In-depth knowledge of Pine Editor; - Familiarity with Trading View platform; - A fine understanding of EMA and its implementation in trading strategies; - Previous track record demonstrating similar tasks completed. I emphasize clarity and efficiency in the script to enhance my trading decisions. Please, get in touch if you can confidently handle these specifications.

I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...existing business site. Additionally, we will require the professional to update SEO settings in all lines of code to reflect the .au domain replacing . Key Responsibilities: - Convert all references of . to .au throughout the entire website - Update SEO settings to accommodate the new domain - Ensure smooth transition without any loss of data or functionality Ideal Candidate: - Proficient in web development and coding - Extensive experience with SEO and domain migration - Attention to detail to ensure no broken links or missing references - Excellent communication skills to provide updates and seek clarification - Familiarity with the business context and ability to work within an existing framework. -Type " to .AU" in your response to show you actually read...

The objective is to develop an application to manage two devices via WiFi (may be increased in the future) I have two devices: Sauna and red light therapy panel. They...two devices via WiFi (may be increased in the future) I have two devices: Sauna and red light therapy panel. They all have a touch control panel and can be connected to your cell phone via Bluetooth and Wi-Fi. Many of the providers also offer you the mobile application already developed (as can be seen in the attached images). The idea is to make a similar application from which the two devices can be managed (set time, lighting, power, etc.). And the history of uses/settings is saved. It could also be evaluated to take the code of the two suppliers' applications and combine them into one, strongly separating ...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

...looking for: - iOS and Android both (maybe quote for each individually, in case we’d have to do one at a time due to cost?) - splashscreen while itloads, then on to the main screen - thumbnails of images, divided into themes - when the user clicks an image it’d take them to the coloring screen - tools: brush, paint bucket, eraser - ability for any coloring to be restricted to be “within the lines”, so it only paints within the white fields - option to choose brush size - option to choose eraser size - color picker or color wheel - undo / redo states - save image (to their photos library) - option to save or pick from some predefined palettes??? - option to save current works in progress??? - does not need to support ads, it’ll ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I kindly ask for payment that I did up to here: - Inspect the code and remove Invisible mode section on profile page for mobile and desktop theme - Enable/fix youtube video's sound for desktop version of script

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I need a master of Photoshop to expertly remove an object that is centrally placed in my photo. The object to be removed is distinctly separate, none of the elements in the image overlap or intertwine with it. The ideal freelancer for this project should possess: - Exceptional Photoshop skills, particularly in object removal - Keen eye for detail to maintain the integrity of the remaining elements - Experience in image manipulation and restoration projects. Your goal is to make the final image look as natural as possible, as if the object was never there to begin with. Efficiency and promptness is appreciated.

I need a professional who can effectively record three of our management meetings for review and analysis purposes. Key Details: - The meetings are expected to continue for three days each. - All mee...meeting and conference settings. - Strong attention to detail and professionalism. - Fast and efficient, without compromising the quality. - Excellent time management skills. - Ability to handle unforeseen recording challenges that may arise. - Familiar with different audio formats and compression settings, to deliver the final product in the desired format. - Understanding of audio editing, to remove unwanted disturbances if needed. Please include samples of previous recordings in your proposal. Your understanding of the project needs and your approach to it will be a decidi...

Hi Andrada, You did a project for me last year and the work was excellent. You did research and data entry for 200 lines on an excel spreadsheet. This project is identical. I need to add 53 entries to the same spreadsheet. I would love to work with you again.

...shopping experience. Key requirements: - The website should have a visually appealing and user-friendly design, with a clear focus on the products. - The primary goal of the site will be to facilitate online sales, so it's essential that the developer has experience in creating successful e-commerce platforms. - It's crucial that the site supports a shopping cart feature, enabling customers to add, remove, and manage their selected products easily. - Customer reviews play a significant role in building trust and credibility. The site must include a review system for customers to share their opinions on the products. - A secure and reliable payment gateway integration is essential. The developer should have prior experience with different payment methods and be able to ...

I meant to erase one page and save it but I erased all of it and saved it. It still says 15KB. Also see attachment. The file name at the bottom is it.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...provide the necessary information for new team members. You'll be responsible for ensuring their details are accurately added to the roster. - Updating Existing Team Members: There may be changes to the current team members' details (e.g. position, contact information, etc.). You'll be updating these details accordingly. - Removing Team Members: As we continue to evolve, there may be a need to remove certain team members. You'll be responsible for removing them from the roster. Ideal Skills: - Strong attention to detail: Considering the sensitivity of the data, it's important that all changes are made accurately and promptly. - Proficiency with data management: A good understanding of data management principles will be valuable in this role. - Excellent ...

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the ch...

I'm in need of a thorough pro...Project Management Portfolio. As I skipped providing specific deliverables, types of projects, and organization method, I encourage creativity and expect innovative ideas for this project. Ideal candidate should have: - Strong understanding of different aspects of project management - Proven track record of bringing original ideas to complex projects - Flexibility and adaptability to work from a blank slate Your task will involve: - Deciding potential deliverables like the project plans, risk assessments, budget reports etc. - Incorporating diverse types of projects perhaps construction, software development or marketing campaigns - Organising the portfolio in a visually appealing and easy-to-navigate way. Looking forward to your creativ...

I'm in need of an experienced interior designer to help me visualize my new living room and bedroom in a modern style through 3D rendering. Key Points: - The design should reflect a modern style, with clean lines and minimalism. - The project will specifically involve the living room and bedroom. Color Scheme: - I'm envisioning a mix of brown, off-white, bright colors, and luxurious colors. - The design should be luxurious and well-coordinated. Ideal Skills and Experience: - Proven experience in interior design, particularly with modern styles. - Proficiency in 3D rendering software. - Strong understanding of color theory and how to combine various colors effectively. - Ability to communicate and interpret design preferences effectively. ** please refer to the attach...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...Responsibilities: Develop Operational Processes: Design comprehensive operational processes covering all aspects of certification, including application procedures, assessment methodologies, documentation requirements, and quality assurance measures. Establish Organizational Structure: Define the organizational structure of the company, including departmental roles and responsibilities, reporting lines, and hierarchy. Ensure Regulatory Compliance: Stay updated with relevant regulations and standards, ensuring that all operational processes align with ANAB Accreditation requirements and ISO/IEC 17024:2012 standards. Quality Management: Implement robust quality management systems to monitor and evaluate operational performance, ensuring adherence to established standards and co...

I'm looking for a skilled photo editor who can completely remove sun rays from an outdoor photo featuring a motorcycle and a person. Your expertise in professional photo editing and manipulation will be crucial to achieving a flawless end result. Here are my requirements: - Complete removal of sun rays from the image. - Retain the overall quality and integrity of the image while executing the task. - Experience working with outdoor photography and dealing with lighting elements. - Excellent attention to detail to ensure a natural look after removal. - The ability to work efficiently to deliver the project within the agreed timeframes.

I'm looking for a qualified Android developer who can modify an existing apk for me. I need some specific modifications to be made. Requirements: - Remove license code request. - Disable external server connection to - Make sure the "REPLACE" button continues to work as intended. The purpose of the "REPLACE" button in this apk is to inject pre-recorded video into the native Android camera or stream transmitted via obs from the pc into the native Android camera. This is a crucial functionality of the apk that needs to be maintained and work perfectly after modifications. Ideal Skills and Experience: - Proficient in Android application development. - Experience in modifying existing apks. - Familiarity with video injection into an Android camera.