Create a linked google sheet to merge rows from my master google sheet
$30-250 USD
Оплачується при отриманні
Looking for someone to create a linked google sheet (pivot table?) from my master google sheet and merge certain columns.
The linked sheet should combine the Yes values in columns T-AC for rows that match each other in columns A-F. Columns H-S will be deleted/ignored in the combined sheet.
In column T, rows that have mised "Yes" or "No" values will be listed as "Mixed" in the merged sheet.
The merged sheet can be automatically updated when I change the master or I can manually run a script each time I change the master.
Ultimately I must be able to publish merged Google Sheet.
Sample of the master sheet here: [url removed, login to view]
Sample of (not linked - combined by hand) sheet here: [url removed, login to view]
ID Проекту: #10183886
Про проект
Доручено:
Dear sir, We can do the task by a Google Script. Script will run, generate report sheet. We can update report automatic by trigger. But it will limit resource. Then I think the best way here is a simple menu to ru Більше
11 фрілансерів(-и) готові виконати цю роботу у середньому за $149
Hello, I am very interested in your posted job involving these skills. I am expert in google spreadsheets and I know these sheets can be linked each other. If you add value in master sheet it will also change on the ot Більше
Hello, I have good Google apps script experience and have made similar projects. It is not clear what meant by " for rows that match each other in columns A-F" Best regards.
I have excellent command on Google Sheets. I have completed complex projects in Google Sheets before as seen in my portfolio. (like - built a reservation system that involved formulas and Macros to consolidate data fro Більше
Hello, My name is Evgeny and I did quite a few Google Sheets projects (even syncing them to 3rd party systems via REST API interface). For your project we can schedule a script that will run once a minute and upd Більше
Hello, I've got already experience in working with google spreadsheet and also I am excellent at using excel so I think I can do your job. Please feel free to contact me with the details. Best regards!