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 · Accepted solution]

Hi @ravikumar060987 

One way of doing this

[binuacs · Accepted solution]

@ravikumar060987 One way of doing this