Divide Column Data into 2 or more columns

[hemant86]

Hi All,

I have data as shown in the screenshot below. Now my Requirement is to segregate the End Date2 column data into two different columns. Is that possible. Please see the screenshot for the required output. Note: Not all employee Ids will be having 2 End dates

INPUT data

 

Required Output                  

EMPCODE	DOJ	DOL	End Date1	End Date2
100716032	6/15/2016	9/19/2021	[Null]	[Null]
105988449	12/18/2019	9/19/2021	9/17/2021	10/17/2021
106026773	1/6/2020	9/19/2021	9/5/2021	10/5/2021
106143203	2/17/2020	9/19/2021	9/16/2021	10/16/2021
106147970	5/25/2020	9/19/2021	9/24/2021	[Null]

Thanks in advance!

[pdave87]

@atcodedog05 100% row 5th is taken care off. I will choose this one 🙂

[hemant86]

Thanks @pdave87 ...Worked like a charm!!😊...Greatly appreciate!!

[hemant86]

Thanks @atcodedog05 ..This is an amazing community😊

[atcodedog05]

Its definitely is @hemant86 🙂

Happy to help : )

Cheers and have a nice day!