Pivot Tip 13 - Use Text to Columns to add extra fields

Kashflow logo
0

David Carter's series of Five Minute Tips aims to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database.

Often with pivot tables you will find that your source data doesn't contain all the fields that are needed to produce a particular report.

When essential fields are missing from the source data, there are two ways to add them:

  • The data may be contained in an existing field, but it needs to be split out into a separate field. Use the Text to Columns command to do this.

  • The additional fields have to be pulled in from a lookup table.

    In this session we'll look at the first option - Text to Columns. If you have recently worked through Pivot Tip 12 and used the Concatenate command, yo...

  • Please Login or Register to read the full article

    The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

    Share this content

    Replies

    Please login or register to join the discussion.

    There are currently no replies, be the first to post a reply.