At this point, you can Close and Load the Editor, and all your data will appear on an Excel worksheet.A new column will appear next to your data set as per the rules set in the Conditional Column. Google the words 'PDF to Excel' and several sites will automatically appear It’s tempting to just click on the first site you see, but it would be foolish to do so. You can continue to add as many clauses to the column as required, and then click OK.If none of these clauses are true, then, we set the Else value to Miscellaneous.We click the Add clause button to create our next rule. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |