Select column when the row value match

[lin.cw.lin (Lin)]

The column length is flexible.
I want to select the columns when the first row equals 1 and Formula row is empty.
Is that possible to use linq to query?

Input

Output

[johnfelix (John Felix Yesuraj)]

Hi @lin.cw.lin

I have attached a workflow, please try it and let me know for any help.

Test_Forum_Solution.zip (3.5 KB)
Forum_Input.xlsx (10.6 KB)

Input:

Output:

Thanks
John

[lin.cw.lin (Lin)]

I see.
There’s is no activity to filter column.
So it can’t be simple like filter data row using an activity or a linq to deal with it right?

[johnfelix (John Felix Yesuraj)]

Hi @lin.cw.lin

There is no activity to filter the column. we have to write a logic to achieve column filtering.
If you want to use filter or linq method, then follow below approach

You can refer the below post for transposing data

How to transpose row to column in datatable?

Hi, I have an example datatable here. [190704%2015_03_16] I want to change row to column. It looks like here. [190704%2015_03_24] How can I do this?

How to transpose column to row in data table?

Hi @makboga Check out the Video link [LINQ | Transpose Datatable Uipath | LINQ Transpose Datatable | Uipath Tutorials | Coderslobby] [How to Transpose Row to Column in Data Table in Uipath | Uipath RPA] Check out this thread Regards Gokul

Thanks
John

[lin.cw.lin (Lin)]

Right…Thanks for your help.