MIP Logo

Tableau Tip: Separate/unmerge auto-concatenation of columns or rows

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

We can notice that, when more than 6 fields are placed in columns or rows, by default, the first two fields are concatenated by a comma.

(in the above picture, fields ‘Region’ and ‘Country’ got concatenated)

To avoid this, select Analysis > Table Layout > Advanced

A new window “Table Options” appears. On the new window, increase the maximum number of rows or columns as desired.

Note that Tableau restricts the maximum rows or columns to 16.

 

 

Share this post