RaviTejaPeri Member since 2015 2 posts
Posted: September 27, 2017
Last activity: November 6, 2018

Sort and group column in excel in openspan

Hi All,

For instance let us consider I have a excel sheet(Assoc_list.xlsx) which has list of associates with their employee id’s, name and other details

• The requirement is to open the first excel and group them based on location and add two rows to differentiate between different locations and sum up the credit points of same location and highlight them and save the excel as shown in the second excel (Assoc_Updated.xlsx)

Can the above functionality be acheived by using only excel connectors?? If yes can anyone explain me how to do this

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn