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!

[atcodedog05]

Hi @hemant86 

Please provide input data in excel file.

[pdave87]

Hi,

Good question, I believe data transform can address this requirement. Can I request the sample input data?

Regards,

Pratik

[pdave87]

@hemant86 Hope below works alright in your use case. Let me know your thoughts 🙂

1.

2. 

[hemant86]

 Hi @atcodedog05 

Attaching the sample data in excel.

[Christina_H]

Here's my version

[hemant86]

Thanks for your response @pdave87 . attaching the input sample 

[pdave87]

@hemant86 Here we go 🙂

[pdave87 · Accepted solution]

@hemant86 Transpose to create extra column and cross tab to parse the date into two - method of aggregation is "First" and "Last" both selected (not shown in screen-print), have a good day! 🙂

[atcodedog05 · Accepted solution]

Hi @hemant86 

My take on it.

Workflow:

Hope this helps : )