Duplicate last column

Advocate II

6 years ago

amitchandak See sample input and output below. The tricky part here is that the number of "Budget revision X" columns can vary, and the function needs to always duplicate the right-most column.

Sample input 1:

Year	Month	Budget revision 1	Budget revision 2
2020	1	903920	1008930
2020	2	239450	345481
2020	3	802380	802389
2020	4	239509	299900

Sample output 1:

Year	Month	Budget revision 1	Budget revision 2	Last budget
2020	1	903920	1008930	1008930
2020	2	239450	345481	345481
2020	3	802380	802389	802389
2020	4	239509	299900	299900

Sample input 2:

Year	Month	Budget revision 1	Budget revision 2	Budget revision 3
2020	1	903920	1008930	901512
2020	2	239450	345481	437457
2020	3	802380	802389	568852
2020	4	239509	299900	345634

Sample output 2:

Year	Month	Budget revision 1	Budget revision 2	Budget revision 3	Last budget
2020	1	903920	1008930	901512	901512
2020	2	239450	345481	437457	437457
2020	3	802380	802389	568852	568852
2020	4	239509	299900	345634	345634

Forum Discussion

Related content

Merge duplicates data in columns

Column count duplicates

Duplicate ranking

Duplicate Columns

remove duplicate value within a row