Pivot Sort and Repeat Rows

eunharanft

New Member
Joined
Feb 9, 2004
Messages
49
In a pivot table how can I let every row to repeat in a column. I mean when I have a couple of items in the column, the first column shows the value only once on top. Is there a way to let it repeat every row? For example,

From
ABC 123
456
789

To
ABC 123
ABC 456
ABC 789

I need to sort it (I tried in Pivot sort, but it didn't work for the field that I have created) but this seems like the best way for now. Any help would be very much appreciated.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Only by using a range outside the PT with a formula like :-
=IF(A2<>"",A2,B1)
(with the data in column A and formula copied down column B).
 

Watch MrExcel Video

Forum statistics

Threads
1,123,271
Messages
5,600,646
Members
414,398
Latest member
dhune

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top