Find Jobs
Hire Freelancers

Powerquery change layout of excel sheet -- 2

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
I have a power query which it is basically a time clock. I have a date and user first name and last and time they clocked in and then clocked out. I need to combine the the two columns based on the date and the user first name and last name. See example below. The final result would be 3/4/2019 megan cunningham 8:58 am 2:17 am 3:17 am 5:58 am 3/5/2019 megan cunningham 9:00 am 2:32 am 3:37 am 6:14 am This would be done for each date . it is basically merging any other column that matches the same date and same username and adding the other times. I have tried to group by and then do a list but i could only bring in one value. I have created a spreadsheet with the results tab on how i want the data to look.
Project ID: 18900306

About the project

9 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am good at Excel and VBA. I prefer to write a vba program to transfer the data as required. Looking forward to discuss further in the chat. -Chandra
$50 USD in 0 day
5.0 (844 reviews)
7.9
7.9
9 freelancers are bidding on average $22 USD for this job
User Avatar
Hi The task is easy I am a software engineer student I can write a python script to change the layout of your excel sheet I did similar tasks I agree to do a test before hiring me to convince you I am free so I can start now Thank you
$10 USD in 0 day
5.0 (11 reviews)
3.6
3.6
User Avatar
Dear Sir, 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 working, fast learner, and honest person. I believe my capabilities would be perfect for your project. So, I'm hoping that you will give me chance. Thank You. Foisal Alam
$20 USD in 2 days
5.0 (1 review)
0.8
0.8
User Avatar
I have read ur project description and i am confident that i can complete your project. In Excel we can use concatenate Formula to merge multiple columns. Waiting for your reply
$30 USD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
What are you doing
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do that. Please tell me about your budget, and delivery time of the report. Your kind quick and kind reply much appreciated................
$20 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hai , I have a proper knowledge and experience in data analysing . I want to do my first job with you. I have a well knowledge in excel advanced function,formulas and VBA. I will finish my work with high quality and accuracy and within a time bound. If your not satisfied in my work there is no need to make a payment to me. I am waiting for your positive reply...... Thank You, Regards, AKILA.K
$10 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Finish project Two laboral days after your request. Relevant Skills and Experience TI profesional Computer Cs.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
we offer a free sample >> It will Take more time but no problem we will handle it together it is an honor to me to serve you >>>
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
crestwood, United States
5.0
7
Payment method verified
Member since Jun 8, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.