I can't figure out an option I'm sure Tableau has.
Its easier to explain with visually so I'll show you what my table looks like and what I'd like it to look like (at least when I export to excel).
Looks like:
Date Group
1st a
b
c
2nd a
b
c
What I would like:
Date Group
1st a
1st b
1st c
2nd a
2nd b
2nd c
So I'd like no merged or blank values as at the moment when I export to Excel I have to unmerge and then manually fill the blanks which for large sets of data is a nightmare.
There are a couple of ways you can do this: