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

Reposition Resize and Delete Chart Elements

Lookup Function Essentials in Excel

Mastering Power Pivot Essentials in Excel L1

Add a Second Axis

Explore a Source Database in Power Pivot

Link Between Worksheets

$6.99 AUD

$9.99

Includes: