Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2012
    Posts
    5
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Copying one cell and pasting multiple times based on value

    I'm working with a report where I work with failures and causes, tallying up totals.

    With the totals I get from the pivot tables, I copy each failure and paste it in a column the number of times the failure occurred (value next to the failure cell). I use that column with the pasted failures to make a pareto chart in MiniTab, so that's why I need it pasted in such a way.

    I have attached a sample of the data I have, and what I am manually doing right now to populate it in the next column, except with much more data than in this sample.

    Any help would be much appreciated!! Thanks!

    Sample metric.xls

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Shouldn't that type of information be in the source data for the pivot table? Why not get it from there?

    Steve

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •