Selecting the Recent Column

[hemantkumar622]

I want the data to be compared from the most recent column to be picked in he brand new column.

For example - I have 5 columns and most recent starts from last column , 5th, 4th , 3rd, 2nd and 1st. If the data on the 5th column , it should pick the data from the 5th col to the new col, If the data  is on the 3rd Column  and 4th and 5th Col is blank, it should pick the data from 3rd column and so on

Illustration -  attached

[mceleavey]

Hi @hemantkumar622 ,

can you please post some example data so we can help you?

M.

[hemantkumar622]

Please refer to the attached file

[mceleavey · Accepted solution]

@hemantkumar622 ,

A bit of transpose and crosstab magic should do the trick:

Hope this helps,

M.

[Maskell_Rascal]

Hi @hemantkumar622 

This should work for you. Transpose, Filter, and a Sample Tool will get you the output needed, and then you can just Join it back to your main data. 

Cheers!

Phil

[hemantkumar622]

Thanks a lot . This works for me

[mceleavey]