Selecting the Recent Column

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

Workflow

Accepted answers

@hemantkumar622 ,

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

Hope this helps,

M.

mceleavey_transpose_crosstab.yxmd

All comments

Hi @hemantkumar622 ,

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

M.

Please refer to the attached file

@hemantkumar622 ,

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

Hope this helps,

M.

mceleavey_transpose_crosstab.yxmd

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

Selecting Data from Most Recent Column.yxmd

Thanks a lot . This works for me

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703