[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 392
  • Last Modified:

repeat text on Excel Pivotable with duplicate rows

Experts,

Please tell me how I would achieve the following;
I have the following data and pivottable, as per attached.

the example data
 the pivot table of what i currently have
This is the pivottable I require, (ignore the format change). Basically I require blank cells to be filled.

 pivot table what I need, ignore format change.
Thanks

 example.xlsx
0
thydzik
Asked:
thydzik
  • 3
  • 3
1 Solution
 
Rory ArchibaldCommented:
If you need to keep the pivot table as a pivot table, then you can't (unless you have Excel 2010).
If not, then copy and paste special-values the pivot table, select the column with the blanks in, press f5, click the Special... button and choose Blanks. Then type = and press the up arrow and press Ctrl+Enter.
0
 
thydzikAuthor Commented:
thanks for the reply, yes, I need to keep it as a pivot table.
0
 
Rory ArchibaldCommented:
Then you are out of luck unless you have Excel 2010, I'm afraid. The only alternative I can think of would be to copy the pivot table to another location and fill in the blanks there.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
thydzikAuthor Commented:
thanks, I will leave this open for a little while, and also try the manual approach.
0
 
Rory ArchibaldCommented:
It would be possible to automate the copying to another sheet for example if that would work?
0
 
thydzikAuthor Commented:
no need, I really like your proposed manual approach.
0
 
Rob HensonIT & Database AssistantCommented:
It can be done by formula but they would be in a separate table.

Assume Pivot Table is in area A3:E20

In G3 put formula:

=IF(A3="",G2,A3)

Copy down and across to cover same size area as the Pivot Table

This is basically saying if the Field Name cell in the pivot is blank use the same as above, otherwise its a new field.

Cheers
Rob H

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now