Concatenate Data in Power Pivot

No reviews yet.

In Excel concatenation joins data from multiple cells together to display in a single cell.Whilst good table design requires data to be recorded in its smallest meaningful components, it is often more user friendly to display data components joined in spreadsheets and Pivot Tables etc.

In a Power Pivot Data Model this concatenated data can then also be applied to new columns and added to a PivotTable.

Data in any columns removed from a Data Model will automatically be removed from a Pivot Table.

Highlights

Concatenate data in a Data Model
Add concatenated data to a Pivot Table
Delete concatenated data from the Data Model and Pivot Table

Duration: 6mins 45secs

$6.99 AUD

from

$9.99

Add to Cart

Includes:

Quality On-demand Video Demonstrations
Step-by-step Learner Guide
Demonstration and practice exercises to boost retention
Lifetime access
Course progress indicator

Concatenate Data in Power Pivot

Highlights

Related Courses

Create Basic Formulas and Functions

HLOOKUP Exact Match Lookup Table with Named Range

Copy and Move Formulas and Functions

If Function Basics

Connect to a Data Source in Power Pivot

Switch Column and Row Orientation

$6.99 AUD

$9.99

Includes: