Insert in the Column

Hi, Attached File is Input File ,i Want output in just like

ASHISH 4-06-2020 Present
ASHISH 4-07-2020 Present…

For All date and For all Name…

Please Help…Book1.xlsx (10.7 KB)

Hi @Shubham_Akole,

Please find the solution.If you have any issues.Let me know. :smiley:

Insert in the Column.zip (25.3 KB)

Regards,
Omkar P

This is not Work in my main file…
Due to DateCounter…Because in file some date is missing in that file…(Week off date or hoilday date)…for eg…17-04-2020…next date is direct 20-04-2020…

Hi @Shubham_Akole,

Remaining is working as you expected.Apart from date we will look for this send your full data excel.

I did as per your attached excel.

Regards,
Omkar P

Book1.xlsx (131.2 KB)

Hi @Shubham_Akole,

Please find the latest solution.If you have any issues.Let me know.
image
Insert in the Column.zip (42.9 KB)

Regards,
Omkar P

Process is Correct
But it is not getting report of VFDG…in process

But it is not getting report of VFDG…in process?

1 row data is missing…

Let me check

Now VFDG row is coming.

Insert in the Column.zip (42.9 KB)