Hide null rows in multi column output

[ppatane]

I am trying to make a vertical histogram from my data by just summarizing how often an item shows up in a list.  I want multiple columns dependent on the count, but I don't want null cells visible.  There's 2700 rows in the data file and about 30 unique items that are being summarized.  Blank cells are being left in place, throwing off subsequent columns. I'd like the blank rows in one column to not affect the next

[Yoshiro_Fujimori]

Hi @ppatane ,

Is this a histogram you want?

Output

Workflow

[ppatane]

Thanks for the charting information! I'll be needing that in the future, for sure!  But I would really like it to look like this (produced with Power Query in Excel

[Yoshiro_Fujimori]

Hi @ppatane ,

Thank you for the clarification.

How about this?

Workflow

Join Multiple Tool configuration

Output

[Qiu · Accepted solution]

@ppatane 
Combination of Tile and Cross Tab should fit for this issue.

[ppatane]

Wow! 2 excellent solutions done completely differently. @Yoshiro_Fujimori's solution is more in line with how my mind and logic work. @Qiu utilized a Tile tool I was unaware of and completely unfamiliar with.  I needed to take a deeper dive to even understand how it was working.  Ultimately, that Tile tool is why I selected that as the solution.