By: Eric Parker
Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can follow him on LinkedIn or sign up for a Tableau Office Hour to work with him directly!
Sometimes, you have too many rows in your #Tableau worksheet and end up with a scroll bar. Annoying, right? Scroll bars mean your users are less likely to see the data at the bottom of your worksheet because it it out of sight and out of mind.
What if you could break the data into multiple columns? For example, instead of displaying 50 states as a single column of 50 rows, could you display it at 2 columns of 25 rows?
The way that Tableau works "out of the box", that's not possible. However, with a little creativity, it is possible! You can use a combination of RANK functions to split a single dimension into multiple columns.
Massive shoutout to Andy Kriebel and his "Watch me Viz" video from December 2022 where I picked up the concepts behind this solution.
Related Resources:
State/Country Abbreviations Workbook (Dropping Soon)
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!