Data Modification

Question

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 NameCom Start DateCom End DateTym ID Tym NameTym Start DateTym End DateKop ID Kop NameKop Start DateKop End DateYvr ID Yvr NameYvr Start DateYvr End DateCgu ID Cgu NameCgu Start DateCgu End DatePlk ID Plk NamePlk Start DatePlk End Date123Qww11/21/201011/21/2010184efw11/21/201011/21/20104847efew11/21/201011/21/2010544wfw11/21/201011/21/20104455wvcw11/21/201011/21/20107584wvwvb11/21/201011/21/2010

S2:

IDNameStart DateEnd Date123Qww11/21/201011/21/2010184efw11/21/201011/21/20104847efew11/21/201011/21/2010544wfw11/21/201011/21/20104455wvcw11/21/201011/21/20107584wvwvb11/21/201011/21/2010

Jonathan-Sherman · Accepted Answer

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