Data Modification

[pranee_007]

Hi team,

I have data in the below format. I filled only one row. Let's say there are n number of rows. I want it in the format shown in S2. Please let me know in case you have any questions. Every four columns in S1 are like a set (ID, Name, Start date and End date) with a prefix in front of them. I want to remove that prefix and transform it to data as in S2.

S1:

Com ID

Com Name

Com Start Date

Com End Date

Tym ID

Tym Name

Tym Start Date

Tym End Date

Kop ID

Kop Name

Kop Start Date

Kop End Date

Yvr ID

Yvr Name

Yvr Start Date

Yvr End Date

Cgu ID

Cgu Name

Cgu Start Date

Cgu End Date

Plk ID

Plk Name

Plk Start Date

Plk End Date

123

Qww

11/21/2010

11/21/2010

184

efw

11/21/2010

11/21/2010

4847

efew

11/21/2010

11/21/2010

544

wfw

11/21/2010

11/21/2010

4455

wvcw

11/21/2010

11/21/2010

7584

wvwvb

11/21/2010

11/21/2010

S2:

ID	Name	Start Date	End Date
123	Qww	11/21/2010	11/21/2010
184	efw	11/21/2010	11/21/2010
4847	efew	11/21/2010	11/21/2010
544	wfw	11/21/2010	11/21/2010
4455	wvcw	11/21/2010	11/21/2010
7584	wvwvb	11/21/2010	11/21/2010

[Jonathan-Sherman · Accepted solution]

Hi @pranee_007,

Is this what you're looking to try and achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan