Create X individual records based on the value of a field

[hellyars]

Okay...

Silly question...

I have a record that depicts the Type of car by quantity across Calendar Years.

The output will be a Tableau .hyper file.  I want to make a chart that depicts the # of cars per year BUT I want an individual mark ('square') for each cart in a given year instead of a single block that sums the # of vehicles in a given year.   I assume, the solution is to create X number of records matches the sum for a given year. 

In the example below, I would need 15 records for CY20, 23 for CY21, 39 for CY22, and 68 for CY23.  Any easy way to do that?

TYPE	CY20	CY21	CY22	CY23
Model_Y	15	23	39	68

[Luke_C · Accepted solution]

Hi @hellyars 

Not sure how you need it oriented, but maybe transpose and use the generate rows tool?