# AutomationEdge RPA Bot | Excel Bot for Data Massaging

**URL:** <https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging/10207>\
**Category:** AutomationEdge Cook Book\
**Tags:** data-massaging\
**Created:** [July 22, 2023, 11:58am UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging/10207 "2023-07-22T11:58:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nidhi.saraiya](https://avatars.discourse-cdn.com/v4/letter/n/ea666f/32.png) [@nidhi.saraiya](https://community.automationedge.com/u/nidhi.saraiya)\
**Post date:** [July 22, 2023, 11:58am UTC](https://community.automationedge.com/t/automationedge-rpa-bot-excel-bot-for-data-massaging/10207/1 "2023-07-22T11:58:16Z")

</div>

"This video showcases an AutomationEdge RPA Bot | Excel Bot for Data Massaging on Employee data.

The bot performs data massaging to get Employee Count by designation and Sort Employees by Roll No.

This RPA bot/workflow uses the following AutomationEdge Plugin steps:  
Microsoft Excel Input, Sort Rows, Group By, Block, Microsoft Excel Output

==============================

Click on the link below to watch complete video:-  
https://www.youtube.com/embed/Lz5dkxL4IHs?feature=oembed&wmode=opaque&list=PLniM5YriMFVJ2IoCtg1qo041InZXUL1rO

#AutomationEdge #SortRows #GroupBy #Block, #MicrosoftExcelInput #MicrosoftExcelWriter #MicrosoftExcelOutput #AutomationEdge #rpa #hyperautomation #workflow #bot #roboticprocessautomation"