- Concatenate column data in Excel using a loop action.
In our day today Excel workbooks, the data is not as per our needs where we have to split data from one cell to individual cells or vice versa. Commonly we used to Concatenate the strings in Excel e.g. Joining First name, Middle name, and Last name, adding dates in strings to get desired data.
- Bot Security Program
- Business Process
- Customer Service & SupportInformation Technology
- Automation Type
- Last Updated
- May 19, 2021
- First Published
- October 30, 2020
- Automation 360
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- Input excel File with test data in three string columns