Search⌘ K

Pivot—Long and Wide Formats

Learn about long and wide data formats.

Long and wide data formats

Data is generally presented in two types of format—long and wide. For data in a long format, each subject contains data represented across more than one row. On the other hand, for data in a wide format, each subject contains data represented in a single consolidated row only.

Illustration of long and wide data formats
Illustration of long and wide data formats

In the example above, we see that the long format stacks ...