Split excel sheet to Columns

[igorfv]

Hi Guys,

How to split the excel sheet below to columns?

My excel:

FIELDS	VALUE
SI_AUTHOR	AAA
SI_CREATION_TIME	03/02/2020 17:03
SI_DESCRIPTION	v2.1
SI_NAME	XPTO
SI_OWNER	Administrator
SI_PARENTID	63817
SI_UPDATE_TS	7/22/20 6:12:41 PM
SI_AUTHOR	BBB
SI_CREATION_TIME	03/02/2020 17:03
SI_DESCRIPTION	v2.1
SI_NAME	XYZ
SI_OWNER	Administrator
SI_PARENTID	63817
SI_UPDATE_TS	7/22/20 6:12:41 PM

Result:

SI_AUTHOR	SI_CREATION_TIME	SI_DESCRIPTION	SI_NAME	SI_OWNER	SI_PARENTID	SI_UPDATE_TS
AAA	03/02/2020 17:03	v2.1	XPTO	Administrator	63817	7/22/20 6:12:41 PM
BBB	03/02/2020 17:03	v2.1	XYZ	Administrator	63817	7/22/20 6:12:41 PM

Thanks,

Igor Valle

[Prometheus]

@igorfv You can group by FIELDS and group by VALUES to remove duplicates, then Cross Tab to pivot your data, then Text to Columns (Split to Rows) on SI_AUTHOR to parse out the concatenated values there.

 

 

 

[igorfv]

My friend, thanks for your support asap, but the workflow result is not the same as above. Could you adjust the workflow, please? The column "SI_NAME" is different.

Igor Valle

[binuacs]

@igorfv 

[igorfv]

Perfect @binuacs! It's working fine.

Have a nice day.

Igor Valle