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

PivotTable Essentials for Data Analytics in Excel

Adjust Gridline Display and Axis Scale

Reposition Resize and Delete Chart Elements

Switch Column and Row Orientation

Add a Second Axis

Define and Use Cell and Range Names

$6.99 AUD

$9.99

Includes: