How to remove all unwanted spaces from excel column

The easiest way would be to get this datable using read range and keep it in data table. Then using for each row activity you need to go one by one row where you will have integer-type variable and if statement which say if column("ReviewedPortal").ToString = "Glassdoor" and column("ReviewedCompany").ToString = "DXC Technology" assign `Variable = Variable +1.

1 Like