Use Excel's PIVOTBY function to fix your data structure!

preview_player
Показать описание
The PIVOTBY function isn't just about aggregation. In this video I show a way to use PIVOTBY to restructure an attribute/value table into a nicely formatted table of entities.

For the accompanying file, click here then select 'Download' from the github page:

#excel #exceltutorial #exceltips #data #analytics
  1. Flex Your Data
Рекомендации по теме
Excel GROUPBY & 0:16:37

Excel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables? 🤔)

You DON'T Need 0:07:12

You DON'T Need PivotTables Anymore (Here Is Why)

Excel PIVOTBY Function 0:19:34

Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845

Excel - First 0:04:59

Excel - First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel - Episode 2633

Excel PivotBy function 0:04:13

Excel PivotBy function - use multiple fields in rows and columns | @efficiency365

Lets learn the 0:03:26

Lets learn the Pivotby Function in Microsoft Excel

5 Problems with 0:09:22

5 Problems with PIVOTBY vs Pivot Tables in Excel

PIVOTBY Function in 0:05:47

PIVOTBY Function in Excel | Automatic Refreshing Pivot Table Report

Try This New 0:12:08

Try This New Formula Instead of Pivot Tables

Excel PIVOTBY Function 0:10:25

Excel PIVOTBY Function | How to use it with Practical Examples | An Alternative to Pivot Tables

Excel GETPIVOTDATA Function 0:09:45

Excel GETPIVOTDATA Function to Pull Data from a PivotTable

Create Pivot Table 0:00:32

Create Pivot Table With Just 1 Function - PivotBy

Groupby and Pivotby 0:15:10

Groupby and Pivotby new Excel formula that every excel user Must know

First Look PIVOTBY 0:09:52

First Look PIVOTBY in Excel | How to use New Excel PIVOTBY Function | Is it Better than Pivot Table?

Excel GROUPBY & 0:21:45

Excel GROUPBY & PIVOTBY Functions | Groupby and Pivotby new Excel formula you Must know

PivotTables but better, 0:10:08

PivotTables but better, using new Excel function: GROUPBY PIVOTBY

Are Pivot Tables 0:07:01

Are Pivot Tables Obsolete? - NEW GROUPBY and PIVOTBY Functions in Excel

Using Excel PivotBy 0:09:32

Using Excel PivotBy function along with Table Slicers

Excel’s Missing Feature: 0:12:57

Excel’s Missing Feature: Slicers for PIVOTBY with Checkboxes

🚨AMAZING Excel NEW 0:02:00

🚨AMAZING Excel NEW Functions: GROUPBY & PIVOTBY

First Play with 0:13:20

First Play with New EXCEL GROUPBY and PIVOTBY function

Excel Quick tips: 0:04:06

Excel Quick tips: GroupBy and PivotBy

Excel How To 0:02:54

Excel How To Sort PIVOTBY Reports Descending by Amount

Nové funkce GROUPBY 0:10:13

Nové funkce GROUPBY a PIVOTBY v Excelu 365 - návod a bonus uvnitř

Комментарии
Автор

It's amazing! Thanks for sharing.

nattawut_chatwiriyacharoen
Автор

I am impressed! How do you know the SINGLE trick? Thanks for sharing!

PS: SINGLE works on a French implementation.

PPS: the PIVOTEVERYNROWS function doesn not need the "n" argument which could be calculated by COUNTA(UNIQUE(attribute))
(unless I am missing an other usage of the function)
Thanks again

philippebrillault
Автор

I don't know what happened, but pivotby is not taking text as a value anymore, at all. Error values only.

TopBam
Автор

SINGLE function doesn't exist en 365 version. Is it possible to work with the @ symbol? How? Thank you.

IvanCortinas_ES