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

[john786]

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

[GaryB]

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

[Chris Davison]

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 ]