Fergus
New member
- Joined
- Feb 4, 2015
- Messages
- 6
- Reaction score
- 0
- Points
- 0
Hello all,
I was wondering if anyone could me with a formula that can do the following
1. Find last cell with a value in row
2. Move last cell with value to desired column
And this formula or VBA do this for all 15000+ rows.
The data looks like the following little illustration (each number represents a column)
Row 1: 12345
Row 2: 1234567
Row 3: 123456789
And I need it do to this
Row 1: 1234 5
Row 2: 123456 7
Row 3: 12345789 9
Numbers 5, 7, 9 would be in the same column
Thanks so much in advance
Any help would be greatly appreciated.
I was wondering if anyone could me with a formula that can do the following
1. Find last cell with a value in row
2. Move last cell with value to desired column
And this formula or VBA do this for all 15000+ rows.
The data looks like the following little illustration (each number represents a column)
Row 1: 12345
Row 2: 1234567
Row 3: 123456789
And I need it do to this
Row 1: 1234 5
Row 2: 123456 7
Row 3: 12345789 9
Numbers 5, 7, 9 would be in the same column
Thanks so much in advance
Any help would be greatly appreciated.