Find non-blanks cells and copy to another worksheet

[A440]

Hi,

I would like to do the following if possible please

1, Find the first non-blank cell in column B, B5. Then copy B5 to Sheet2 A1.
2, Also copy cell A5 to Sheet2 A2
3, Then find the next non-blank cell in column B, B11. Then copy B11 to Sheet2 B1.
4, Also copy cell A11 to Sheet2 B2
And so on

Please see attached file

Happy to use VBA etc.

Many thanks

[José Augusto]

Hi
In Sheet1!C1 use the formula (and copy down)

Please Login or Register  to view this content.

In Sheet2!A1 use the following formula and copy forward

Please Login or Register  to view this content.

In Sheet2!A2 use the following formula and copy forward

Please Login or Register  to view this content.

See the file

[A440]

Many thanks for you reply. I now have this working but I would like to move the data etc to a different cell, when i move it, it no longer works.
I would like on Sheet1 A1 to be I5 etc. And Sheet2 formulas would start at W2 andW3. I tried transposing all the cell refs but I am missing something, or is it not possible to do it this way.
Thanks

[A440]

Thanks again for your reply, I have managed to figure out what I had done wrong. All working now

[José Augusto]

Thanks for your feedback and rep.