'Ungroup' or Disaggregate Rows

1

Hi, is there a way to ungroup or disaggregate rows?

For example, assume the following:

Column A = Date
Column B = Count of unique visitors

Is there a way to 'ungroup' column B and add new unique rows if the count is higher than 1? The result would be a count of 1 unique visitor for each row but if aggregated (or re-aggregated I guess) by date, then the uniques would re-sum to the original value.

So, if

Row 1 values: Date = 2022-08-01, Uniques = 1
Row 2 values Date = 2022-08-02, Uniques = 2

Then the 'ungroup' would replace row 2 with 2 new rows with the same date value (2022-08-02) and each with a Uniques value of 1.

Possible?

2

Well, I answered my own question. It's the repeat rows function and it's really simple. Sorry :slight_smile:

1 Like
3

Yes, the "Repeat rows" action.