Forum Discussion
Generating rows of data based on count in column
I see. So back in your second table, you can add a custom column with the following code:
{ 1..[Count]}That will produce a list starting at 1 to whatever the # in count is. You can go ahead and expand that out
Append with table one, and you get this table
Only interested in Category, Result and Average, so can remove all the other columns.
Then just merge the Result and Average columns and you the following table:
You can merge queries as new.
then just expand out the average column
Let me update the question. The categories in the aggregated table might match the ones in the data table, but they might also be different.
In this case the Merge + expand action suggested gives me:
or if I expand all the columns then:
What I actually need to achieve isI see. So back in your second table, you can add a custom column with the following code:
{ 1..[Count]}That will produce a list starting at 1 to whatever the # in count is. You can go ahead and expand that out
Append with table one, and you get this table
Only interested in Category, Result and Average, so can remove all the other columns.
Then just merge the Result and Average columns and you the following table:
Perfect, thank you!