Powerquery change layout of excel sheet -- 2

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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.

Введення даних Обробка даних Excel Visual Basic

ID Проекту: #18900306

Про проект

9 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

Доручено:

cgullapalli

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 за 0 дні(-в)
(844 відгуків(-и))
7.9

9 фрілансерів(-и) готові виконати цю роботу у середньому за $22

kyosra

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 Більше

$10 USD за 0 дні(-в)
(11 відгуків(и))
3.6
ITspecialist247

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 Більше

$20 USD за 2 дні(-в)
(1 відгук)
0.8
rajamajid1981

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 за 1 день
(1 відгук)
0.4
Surajchapadiya24

What are you doing

$25 USD за 1 день
(0 відгуків(и))
0.0
MalikUsmanHaider

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 за 4 дні(-в)
(0 відгуків(и))
0.0
akilak9698

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 Більше

$10 USD за 0 дні(-в)
(0 відгуків(и))
0.0
gadingenieros

Finish project Two laboral days after your request. Relevant Skills and Experience TI profesional Computer Cs.

$25 USD за 2 дні(-в)
(0 відгуків(и))
0.0
melsha15

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 за 1 день
(0 відгуків(и))
0.0