Đang Thực Hiện

Powerquery change layout of excel sheet

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic

Xem nhiều hơn: excel vba look data sheet, price list excel sheet, change data excel sheet using program, power query tutorial, power query change data source, power query excel 2016, query editor excel 2016, get & transform and power pivot in excel, excel.workbook power query, excel query table in same workbook, excel queries and connections, excel spreed sheet look project, list cities excel sheet, excel sheet look porject sheet, sample excel sheet inventory net change, client list excel sheet, list countries world cities excel sheet, list countries cities excel sheet, country state list excel sheet, excel sheet company list

Về Bên Thuê:
( 7 nhận xét ) crestwood, United States

ID dự án: #18895802

Được trao cho:


Hello There, I am lalit verma. I have read the description and understand your requirements. i'm good at my skills and i know how to done these type of works. Please send me further instructions about the job if Thêm

$15 USD trong 1 ngày
(0 Đánh Giá)

7 freelancer đang chào giá trung bình $23 cho công việc này


Hi, I'm an expert in Data Entry. I understood your all requirements. I have done many projects like this. I'm ready to start now. Regards, Noor

$25 USD trong 0 ngày
(188 Nhận xét)

Hi there, I have seen your project details, I can do this data filling job in the excel file. I understand your requirements. Please message me, I am ready to start now. Regards, Mou

$30 USD trong 1 ngày
(86 Nhận xét)

!!! Dear Honor !!! We Can Help You Make That Happen !!!We Are Looking for Opportunity...........................

$10 USD trong 1 ngày
(0 Nhận xét)

Hi, how are you? I have read your project. If you give me the job, then I can do the job. If you wish, you can discuss with the massage. Thank you.

$15 USD trong 1 ngày
(0 Nhận xét)

Hope you are doing well!!! I can fulfill your project requirement in short time with quality and budget. I have gone through your project requirement to build website & design which match my expertise.I am proficien Thêm

$30 USD trong 0 ngày
(0 Nhận xét)

hello sir. i am interested to this project. if you give me change , i will do my best. i am serious for this.

$35 USD trong 1 ngày
(0 Nhận xét)