Bringing together data
I have a column of 7 cells which may or may not contain comments. Such as
A1: Comment 1
A2: Comment 2
A3:
A4: Comment 3
A5: Comment 4
A6:
A7: Comment 5
i wish to have
B1: Comment 1
B2: Comment 2
B3: Comment 3
B4: Comment 4
B5: Comment 5
B6:
B7:
I've tried if statements & i can't get it right, please can any one help.
Thanks
|