5/3/2023 0 Comments Turn pdf into excel table![]() For the purpose of this data set, if the Transaction column contains the value E-TRANSFER (case sensitive) then the category assigned to it should be Email Transfer Received.In the dialog box for Conditional Column, insert the column name (in this case it’s Category), and then assigned conditions through clauses.Click on Add Column > Conditional Column and a dialog box will appear asking you to assign conditions/clauses to organize your data. Next, we will use the Conditional Column command, which is quite useful in cleaning up and organizing bank data.A dialog box will appear asking for the number of rows that need to be removed. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |