Extract specific columns from excel

Hello,
I have a Excel table with multiple columns.
But I need to extract only few of them.

A B C
Result A1 Result B1 Result C1
Result A2 Result B2 Result C2

And so on…

I don’t have any header, because I was using data scrap method.
So how would be happen to take Column A and Column C for example?
Then put them in another Excel, so I can manipulate the data better.

Thanks in advance.

Hi,

use Filter DataTable activity and you can move the wanted columns to a different datatable, then you can write it to a excel.

2 Likes

Main.xaml (8.5 KB)
make changes as per your need

2 Likes

Hello,
Thanks you guys.
You both give me the solution.
@sarathi125
@ImPratham45

Welcome!
Happy Automation