Related Posts
Is there a videogames bowl?
Additional Posts in Excel Genius
What are the most typical models you all build
Best pdf to excel converter?
What's the F4 analogy in Office 365?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Filter on blank, so you get only the cells without labels. In e.g. A2 enter =A1, then fill to all blanks. You can use Ctrl D as a shortcut to fill all selected on a filtered range without overwriting the actual labels.
I'm also guessing here at what you're really asking.
Subject Expert
Use a reference formula (such as index match)?
Not sure I'm following the goal here
As an example, I want all the rows in that section to show "total" before "x", then repeat "x" in the next section
Like this:
Normally I would "repeat item labels" if it was in a pivot table but this is just raw data