Is there any better way to do data massaging in excel without using keystrokes?
Currently I have more than 10k data in excel. Require a lot of data massaging for every column i.e. more than 10 columns. For example first column I need to calculate length of character. The next column I need to calculate Number of days etc. After I run the whole process it took me more than an hour to complete everything. Because a lot of for each row activity. (This is how I massage the data for every column).
I try to avoid opening the excel and use click activity/keystrokes activity which maybe took me lesser time to complete.
I really need other opinion on this. Thanks