Could you please come up with the data
and the mockup of the trivial result in Excel?
I'd like to help.
The closest approach in Tableau would include binning the data.
For it to work as expected, one should have the [Row ID] column --
the analog of the ROW() function in Excel -- right in the datasource.
Please find the attached (using a modified Excel file as a datasource).
Hope it could help.