Set up a pivot table on GSHEET

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

Data Entry Data Processing Excel

Project ID: #17400710

About the project

35 proposals Remote project Active 5 years ago

Awarded to:

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 More

€55 EUR in 1 day
(83 Reviews)
6.0

35 freelancers are bidding on average €107 for this job

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 More

€100 EUR in 2 days
(431 Reviews)
8.3
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 in 1 day
(308 Reviews)
7.3
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 More

€100 EUR in 3 days
(277 Reviews)
7.2
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 More

€122 EUR in 2 days
(66 Reviews)
6.9
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 More

€99 EUR in 3 days
(99 Reviews)
6.5
Ashisjena2015

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

€99 EUR in 0 days
(44 Reviews)
5.6
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 in 3 days
(65 Reviews)
5.5
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 in 3 days
(23 Reviews)
4.7
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. More

€30 EUR in 2 days
(46 Reviews)
4.8
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 in 2 days
(15 Reviews)
4.5
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 in 2 days
(32 Reviews)
4.4
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 in 1 day
(12 Reviews)
3.7
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. More

€34 EUR in 1 day
(11 Reviews)
2.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 More

€50 EUR in 3 days
(1 Review)
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:- More

€32 EUR in 6 days
(1 Review)
0.2
ayazal

BECAUSE I HAVE A GOOD EXPERIENCE IN THIS WORK I AM DOING THIS TYPE WORK FROM 2 YEARS IF YOU WANT TO JOIN ME AS A PROJECT SO I WILL MAKE IT SPECIAL FOR YOU WITH MY BEST EXPERIENCE.

€155 EUR in 3 days
(0 Reviews)
0.0
Pank789

I have checked the sheets & descriptions you have in google drive. I have a few questions in this regards. Please ping me for more discussion. Hello, I have vast experience in generating reports using advance ex More

€50 EUR in 0 days
(0 Reviews)
0.0
singhnitin2001

Shall deliver with the best output Relevant Skills and Experience Excel with analytics

€155 EUR in 3 days
(0 Reviews)
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 More

€110 EUR in 3 days
(0 Reviews)
0.0
Akshayseth25

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

€111 EUR in 3 days
(0 Reviews)
0.0