How do I split multiple rows of data in a excel using C#

See more:

C#

i have a excel having multiple rows of data like user id, name, start time and end time.
i want to split the data into 2 tables using C# code like:
1. i need 1 table with user id, name, start time
2. 2nd table with user id, name, end time

User ID	Name	Date	start	             end	       first? last?	logic
111	David	11/18/2022	2022-11-18 07:36  2022-09-15 07:45 first   No   first
112	Leo	11/18/2022	2022-11-18 07:46	2022-09-15 07:46	No	  last	last
112	Leo	11/18/2022	2022-11-18 08:34	2022-09-15 08:34	first last	both

Note: first refers to start time
last refers to end time
logic refers having both start and end times.

What I have tried:

tried using pivot tables in excel