Complete a table with data. Google Sheets Experts
the ex,
When (source row1):Name=name1, Options={opt1: [opt11, opt12, opt13], opt2: [opt21, opt22]}, Code=code1, Brand=brand1
and then (sep.“Out” out.- result sheet, option_name - from the matching tables of the option group to its displayed name take name, value_name - from the matching tables of the value of the option to its displayed name take name):
name1, option_name(opt1) value_name(opt11), option_name(opt2) value_name(opt21);name1, option_name(opt1) value_name(opt11), option_name(opt2) value_name(opt22);name1, option_name(opt1) value_name(opt12), option_name(opt2) value_name(opt21);name1, option_name(opt1) value_name(opt12), option_name(opt2) value_name(opt22);name1, option_name(opt1) value_name(opt22);name1, option_name(opt1) value_name(opt21) value_name(opt21);name1, option_name(opt2) value_name(opt1) value_name(opt13), option_name(opt2) value_name(opt2) value_name(opt22);
and (sep.“Out” – out.- result sheet, the neighboring cell - generate the full type code:brand1-code1-opt11-opt21;brand1-code1-opt11-opt22;brand1-code1-opt12-opt21;brand1-code1-opt12-opt22;brand1-code1-opt13-opt21;brand1-code1-opt13-opt22;brand1-code1-opt13-opt22;
2ndIn the Google Sheets table, the data from several columns automatically form a summarized column by spreading lines into columns.the ex,
When (source row1):Group=group1, Values=val1,val2,...,valN
and then:
group1, val1;group1, val2;...group1, valN;
ThreeConfiguration of validation and conditional format (possible).PS: Detailed and starting table in the message.
Client's review of cooperation with freelancer
Complete a table with data. Google Sheets ExpertsVery good, despite the difficulties. I recommend !
Freelancer's review of cooperation with Ilona Krylova
Complete a table with data. Google Sheets ExpertsДетальное объяснение задачи, быстрая оплата сейфа.
Заказчика рекомендую
![]()
Current freelance projects in the category Data Parsing
Scrape the database and add it to the Telegram chatScrape the database from List.ua and add by numbers to the Telegram chat. The chat is about repairs and interior design. Data Parsing, Customer Support ∙ 10 hours 24 minutes back ∙ 19 proposals |
It is necessary to develop a Telegram bot for monitoring cars from auctions in the USA (Copart, IAAI)A Telegram bot is needed for automatic searching and monitoring of "BUY IT NOW" cars at auctions in the USA (Copart, IAAI). The bot should operate automatically and send notifications about new cars that meet the specified filters.Main functionalityFilter settings: 1. Car… Data Parsing, Bot Development ∙ 17 hours 57 minutes back ∙ 66 proposals |
Parsing products, preparation for import to WPScrape the full catalog of these websites: https://svit-mebliv.ua/ https://kompanit.com.ua/ru https://amia.com.ua/ https://mebliromax.com.ua/ https://pehotin.com.ua/catalog/ https://www.sokme.ua/ru/ All products need to be combined into one general table for import into WP.… Web Programming, Data Parsing ∙ 3 days 10 hours back ∙ 57 proposals |
A specialist in Telegram promotion is required.
28 USD
Tasks: invite real users from the username database to new chats and send messages to the target database. Only quality traffic and work with a live audience are of interest — performers using bots, fake engagement, or low-quality methods are requested NOT TO DISTURB. Work… Data Parsing, Social Media Marketing (SMM) ∙ 8 days 10 hours back ∙ 9 proposals |
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 12 days 5 hours back ∙ 13 proposals |