Look for first non blank column in row and move the entire r
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Look for first non blank column in row and move the entire r

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    e.g
    A B C D E F H I J K
    1 2 3 4 5 7
    2 3 4 1 4 5 6
    1 2 6 7 9 7

    to
    A B C D E F H I J K
    1 2 3 4 5 7
    2 3 4 1 4 5 6
    1 2 6 7 9 7


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Essex, England
    Posts
    459
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I may be being thick here, but aren't your before and after examples rather similar?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-19 22:56, john786 wrote:
    e.g
    A B C D E F H I J K
    b b b 1 b 2 3 4 5 7
    b 2 b 3 4 1 4 5 b 6
    b b b 1 2 6 7 b 9 7

    to
    A B C D E F H I J K
    1 b 2 3 4 5 7 b b b
    2 b 3 4 1 4 5 b 6 b
    1 2 6 7 9 7

    where "b"s are blank cells...

    John.... blanks don't quite align themselves as we'd like them to on this board, so I editted your post with "b"s.... hope you don't mind..... this will also flag it up to the top of the queue

    [ This Message was edited by: Chris Davison on 2002-03-21 12:18 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com