We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

repeat text on Excel Pivotable with duplicate rows

Travis Hydzik
on
Medium Priority
402 Views
Last Modified: 2012-08-14
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
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Travis HydzikVarious
CERTIFIED EXPERT

Author

Commented:
thanks for the reply, yes, I need to keep it as a pivot table.
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
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.
Travis HydzikVarious
CERTIFIED EXPERT

Author

Commented:
thanks, I will leave this open for a little while, and also try the manual approach.
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
It would be possible to automate the copying to another sheet for example if that would work?
Travis HydzikVarious
CERTIFIED EXPERT

Author

Commented:
no need, I really like your proposed manual approach.
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
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

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.