Results 1 to 12 of 12

very complicated transpose

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Utah
    MS-Off Ver
    Excel 2007
    Posts
    74

    very complicated transpose

    Okay here it goes, The attached book on the day sheet needs to have columns c-p from row 1-37 need to be transposed to another book. That is the simple part. The problem I am having is that there needs to be multiple copies of each column based on the number of specific cells in that column that are greater than 0 (60,62,64,66,68,70,72,74,76,78,80,82). So if column c has rows 60,64,70 greater than 0,then there would be three copies of column c transposed. Is this a possibility at all? and does anyone want to take on the challenge?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1