Forum Discussion
How do I repeat row values in a matrix?
This seems like a simple formatting issue, but I don't see any options to make it happen.
I have a matrix with three categories in Rows, dates going across in Columns, and values going down.
The problem is, when I expand all my categories across the matrix, I just get a single instance of each category level, without repeating values. The problem is, when I export the data, I want it to look like a table, with repeated values.
In other words, right now it looks like this:
| Category 1 | Category 2 | Category 3 | 1-Jan | 2-Jan | 3-Jan |
| Food | Fruit | Apples | 2 | 1 | 2 |
| Oranges | 4 | 7 | 6 | ||
| Bananas | 9 | 5 | 2 | ||
| Vegetables | Celery | 8 | 9 | 5 | |
| Carrotts | 6 | 2 | 6 | ||
| Non-Food | Paper | Toilet Paper | 3 | 2 | 1 |
| Paper Towels | 7 | 8 | 4 |
And I want it to look like this:
| Category 1 | Category 2 | Category 3 | 1-Jan | 2-Jan | 3-Jan |
| Food | Fruit | Apples | 2 | 1 | 2 |
| Food | Fruit | Oranges | 4 | 7 | 6 |
| Food | Fruit | Bananas | 9 | 5 | 2 |
| Food | Vegetables | Celery | 8 | 9 | 5 |
| Food | Vegetables | Carrotts | 6 | 2 | 6 |
| Non-Food | Paper | Toilet Paper | 3 | 2 | 1 |
| Non-Food | Paper | Paper Towels | 7 | 8 | 4 |
Anyone know how to make this happen?