How to add 2nd for each row in the 1st for each row

dt_final for each row.xlsx (11.6 KB)
Hello
i am not sure if i express clearly in the attached. i need to have 2nd for each row for inputting data in our tool. it is 1 big for each row contains 2nd for each row. but i only have one source of data.
if possible, pls help me for the solution.

i ll appreciate your support much
mz

Hi @mingzi.dugu

What is your process? What do you want to enter in the tool from the excel file?

dt_final for each row.xlsx (496.9 KB)
Hello Varun
thank you very much for your fast feedback. i am afraid to ask you because i have troubled you to much.
if possible, pls help to check the attached. it is a little complicated.
appreciate your big help!
Mingzi

Hi, Varun
may i know how to delete my attachements after the issue is solved. i donot want to keep the infor in with our company title.
thanks a lot
mingzi

Hello all
does any one can help me with the for each row in the attached.
thank you very much for your help in advance!
Mingzi

Could you please explain clearly your requirements?

dt_final for each row.xlsx (464.7 KB)

Hello Ganesh
thank you so much for your feedback. it is a little complicated.
in the excel, i tried to explain my problem.
Hope it is clear for you, i ll appreciate your help very much
nice day, Mingzi

1st Issue- Using this concept you can remove hh:mm:ss from the string

2nd issue- Need clear information. I didn’t get the clear outcome from that excel

Hello Ganesh
thank you very much for your help.
i donot know how to describe the for each row issue. is it possible we plan a short meeting, is it okay with you?
thanks a lot
Mingzi

Yes, we can

Hello Ganesh
glad to know it is okay,
how to invite you? it seems i donot have your email address.
thanks
mz

Share me your LinkedIn name. Will ping you over there

Hello Ganesh
thank you very much for your support
kumar.varun2 contacted me before your text. i have booked the meeting with him.
hope with it, i can solve the issue.
appreciate your quick help always, have a nice day! Ganesh
mz