Formatting DataTable - GroupBy

[JoaoSantos489]

Hey guys,

I am facing alot of difficultys on this one, any help will be appreciated.

My challenge is getting this DataTable (colTimesAux)

Name	Number	Day1	Day2	Day3
John	00009183	8000	09:00-18:00	09:00-18:00
Tess	00004983	18:00 - 24:00	09:00-18:00	09:00-18:00

Looking like this ( new table colTimes)

Number	Times
John	8000
John	09:00-18:00
Tess	18:00 - 24:00
Tess	09:00-18:00

I have tried using GroupBy but I cant get around it...

Thanks in advance

[Nogueira1306 · Accepted solution]

Hey! I dont think tha tyou can do a Group By because you have different times in the same record/line.

I think that the bes toptionwould be for you to have  each time on a line.

Like:

Name	Number	Day	Time
John	00009183	Day1	09:00-18:00
John	00009183	Day2	09:00-18:00
John	00009183	Day3	09:00-18:00

Something like that

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!