Powerquery change layout of excel sheet -- 2
$10-30 USD
Оплачується при отриманні
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.
ID Проекту: #18900306
Про проект
Доручено:
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
9 фрілансерів(-и) готові виконати цю роботу у середньому за $22
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 Більше
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
I will do that. Please tell me about your budget, and delivery time of the report. Your kind quick and kind reply much appreciated................
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 Більше
Finish project Two laboral days after your request. Relevant Skills and Experience TI profesional Computer Cs.
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 >>>