The address column will be used to create the PivotTable, a Pivot chart or Pivot View report just like you would add any other column. NOTE: If you're using Excel 2016, use CONCAT function. To do that, you need to use CONCATENATE function which will allow you to join the columns together. In this table, you can create a PivotTable with combined Ship_city and Ship_state text values. An example, you may wish to combine names field with address field to form a single column or combine some texts with a formula driven value. When creating Pivot table you may want to combine data from two or more columns to form a single column. Concatenate is an excel function that allows you to join two or more strings together.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |