Завершено

Set up a pivot table on GSHEET

Hello,

Objectives:

We want to set up a pivot table that enable to mix two databases into a third that extract the data by the way of a unique key of each of the lines from the 2 first databases.

Deliverable:

Data will be entered manually into the sheet in red.

The pivot table is in black.

In the pivot table only the ID for USER and ASSET will be entered in a mixed way.

Please find details here of the specification: https://docs.google.com/presentation/d/16AnSzPLcblBTV1k2qSg4iFcFtLiShyjGFwzynvodeZs/edit#slide=id.g3da0259b73_0_1

Example of a pivot table here of the deliverable:

https://docs.google.com/spreadsheets/d/1mTXOcHoK3AtGYMTTMDoK5GMaYxvwxSkwqmxMnfch850/edit#gid=1676752564

Квалификация: Ввод данных, Обработка данных, Excel

Показать больше features cnet pivot table service, update pivot table vbs, vsto pivot table excel, google sheets pivot table filter, google sheets pivot table format, google sheets pivot table count, google sheets pivot table calculated field, google sheets pivot table multiple sheets, google sheets table, google sheets sortable table, google sheets pivot table group by month, data entry, virtual assistant, excel, word, microsoft office, microsoft excel, create excel pivot table net, vsto pivot table, aspnet editable pivot table

О работодателе:
( 39 отзыв(-а, -ов) ) CARAMAN, France

ID проекта: #17400710

Поручен:

royalcalif

Let me know the full specification of project. Hi Mr. Employer, Basically the Google sheets is running by Java script. So we have some knowledge in the JS. I have lot of experience in Google sheets and I can do this p Больше

€55 EUR за 1 день
(74 отзывов(-а))
5.7

36 фрилансеров(-а) в среднем готовы выполнить эту работу за €105

schoudhary1553

Hi there, Warm Greetings We came along with your request for Set up a pivot table on GSHEET and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have profe Больше

€100 EUR за 2 дней(-я)
(312 отзывов(-а))
7.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

€100 EUR за 1 день
(220 отзывов(-а))
6.9
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business Больше

€100 EUR за 3 дней(-я)
(214 отзывов(-а))
6.8
€155 EUR за 1 день
(78 отзывов(-а))
6.6
antoinepal

Hello, I am an experienced Data Analyst with advanced skills in Excel. I can give you quality work. Please check my portfolio in order to see my work. Just give me the opportunity to show you what i can do. Than Больше

€122 EUR за 2 дней(-я)
(29 отзывов(-а))
6.0
TechnoGuruu

Hi, I have checked your project descriptions and both the links which you have mentioned there. As you wanted to create this automated sheet, I will design the same for you quickly. I have many years of experience Больше

€99 EUR за 3 дней(-я)
(68 отзывов(-а))
5.6
abdulkarim97

Hello sir I saw your project now and I understand what you want so if you give me your project then I will give you quality work so please message me for quality work

€70 EUR за 3 дней(-я)
(16 отзывов(-а))
4.3
€70 EUR за 3 дней(-я)
(7 отзывов(-а))
4.3
Ashisjena2015

Hi, I am an advanced excel expert. Please discuss in detail over chat now. Thank you..........................................................................

€99 EUR за 0 дней(-я)
(33 отзывов(-а))
4.9
sevillajk01

hi! let me help you with your project. I have read your requirements and I'm confident that I can deliver it. thanks hello I can do this project but why I can see duplicate project just like this!

€85 EUR за 3 дней(-я)
(22 отзывов(-а))
4.3
vandana1986

Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day,

€155 EUR за 2 дней(-я)
(11 отзывов(-а))
4.3
prasannjeetp

Hi, I have seen your proposal. I have very good knowledge of google sheets and pivot. I can do this job for you in minimum budget and time with quality. Please come on chat for more details. Awaiting your response. Больше

€30 EUR за 2 дней(-я)
(46 отзывов(-а))
4.6
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas etc. thanks

€90 EUR за 2 дней(-я)
(16 отзывов(-а))
3.6
AlieGhazanfar

Hi there, I see your all attached google sheet and 100% understand that what you need, You want that If you just type ID for USER and ASSET key so you all data will automatically given into your other blank rows. Больше

€34 EUR за 1 день
(11 отзывов(-а))
2.9
Nicecreator

Hi there, i understand your requirement and can do the work perfectly using my outstanding experience. Please award me the project so that we discuss it more Thank you.

€30 EUR за 1 день
(9 отзывов(-а))
2.4
khaiminhp

I have COMPLETED the PIVOT table as below: [login to view URL] If you enter the User ID and ASSET ID, you would be able to get DYNAMICALLY the result Больше

€30 EUR за 0 дней(-я)
(4 отзывов(-а))
1.9
ITspecialist247

Hello, Thank you for your job posting. Your job post has caught my attention because I'm a data entry specialist. I have comprehensive experience in Copy Typing, Data Entry, Data Processing, and Excel. I’m a hard wor Больше

€50 EUR за 3 дней(-я)
(1 отзыв)
0.8
Rishabhwadhwa04U

Hello Sir, I am a semi-qualified Chartered Accountant and Accounting and Finance Post Graduate with 3 years work experience. I will work for company and individual with on-time delivery and 100% Quality. My Gigs are:- Больше

€32 EUR за 6 дней(-я)
(1 отзыв)
0.2
Akshayseth25

I have 5 years of experience working on large database and advance excel. I can surely get you the desired outcome.

€111 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0
kainoka73

first create a new PIVOT table . select the table containing the data I want to use. After that insert table and click the PIVOT table command. Now dialog box will appear do the commands fill in it. We can See blank Больше

€110 EUR за 3 дней(-я)
(0 отзывов(-а))
0.0