Last Column Value

[BRRLL99]

Hi

I have following data , expected result I'm looking for last value of the column, I'm looking for optimized workflow

SL NO	Column-1	Column-2	Column-3	Column-4	Column-5
100	A	B	C	D	E
101	S	D	G
102	F	R	A	H
103	G	J	W
104	S	G
105	M	G

Expected Output:

SL NO	Colkumn-1	Column-2	Column-3	Column-4	Column-5	Last Value
100	A	B	C	D	E	E
101	S	D	G			G
102	F	R	A	H		H
103	G	J	W			W
104	S	G				G
105	M	G				G

[Christina_H · Accepted solution]

Try this

[RobertOdera · Accepted solution]

Sure thing, @BRRLL99 

Please see below.

I hope you find it helpful - Cheers!

[RobertOdera]

You're most welcome @BRRLL99