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

Chart Examples and Elements

Timelines in Power Pivot

Upper Lower and Proper Functions

Link a Chart from Excel to Word

VLOOKUP Range Lookup Table with Absolute References

Add Excel Tables to a Data Model in Power Pivot

$6.99 AUD

$9.99

Includes: