Row transfer into column

ravikumar060987

Good Day,

Please guide me, I have input as follows and required output as mentioned. Which tools and logic will be used to get the output?

		Input
Column1	Column2	Column3	Column4	Column5
MALAYSIA	MY-1	1 POSITION	A POSITION	40000
		Difference		40000
CHINA	CH-1	1 POSITION	A POSITION	50000
		2 POSITION	B POSITION	50100
		Difference		100

	Output
Column1	Column2	Column3	Column4	Column5	Difference
MALAYSIA	MY-1	1 POSITION	A POSITION	40000	40000
CHINA	CH-1	1 POSITION	A POSITION	50000	100
CHINA	CH-1	2 POSITION	B POSITION	50100	100

Felipe_Ribeir0

Hi @ravikumar060987 

One way of doing this

Row transfer into column.yxmd