Google Sheets Pivot Table
$30-250 USD
Pago na entrega
I have an Google Sheet available to radio stations to input their top 30 songs for the week. There is a send button currently in that document that sends me an email with the .xls file attached.
My goal is to take all of those files from the radio stations (about 60 right now) and combine them into one document, which averages out the positions of the most commonly played charts.
The document is formatted into the proper columns for artist and song name, I just to know how I can use the pivot table to compile all those sheets into one master sheet, which I can then post online.
Here is a link to the template - [url removed, login to view]
ID do Projeto: #11577028
Sobre o projeto
8 freelancers estão ofertando em média $146 nesse trabalho
Hi, I am good at Excel and Google sheets. I have gone through the description. Looking forward to discuss in the chat.
Hi there. I can build the necessary pivot table for both google sheets and excel. Contact me and we do it. Thanks..
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, I have entire posting read , I agree to your terms & conditions. I have an 6 years of experience of doing data entry. I will assure you the results will be as per expectation. Very good with Key board skills, basic Mais
Hi, I have understood your requirement. Please find below the proposed solutions steps: 1) I will create a master excel workbook with macros. 2) First sheet of master workbook will have option to add file name (right Mais