Questions? We have answers.

Copying Account and Account Description Information

Article author
Jonathon Plowman-Samson
  • Updated

In this example, we'll copy a file's Account Number and Account Description information that's contained in the same cell. We'll then split this information into separate columns.

Begin by creating an empty column to the left of the current account information:

image_-_2021-01-07T124456.106.png

For all the rows containing data, use the formula below to copy the account information:

=IF(ISTEXT(B6),B6,A5)

This formula states that if cell B6 contains text, then copy that cell. If B6 does not contain text, copy the above cell. This will allow account information to be copied until a new account is encountered.

2019-06-19_16-06-45.png

Copy the formula to the bottom of the file by selecting the cell containing the formula and using the Fill to Bottom function:

image_-_2021-01-07T124529.707.png

Copy the account information column and paste as Values.

image_-_2021-01-07T124546.622.png

Your data file will now look like the screenshot below, and it's ready to be saved.

image_-_2021-01-07T124605.586.png
Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.