I have an EXCEL file which consists of two worksheets (1 & 2).
Data input into WS1 is transferred (by means of macro) and transposed in WS 2.
e.g. Sheet 1 entries
D E
11 Name Smith
12 First name Michael
13 Country UK
14 Age 26
and a new record
D E
11 Name Brown
12 First name Susan
13 Country
14 Age 21

become

Sheet 2
A B C
D
1 Smith Michael UK 26
2 Brown Susan 21

However, if a cell is left empty on Sheet 1 (E13 above), the info from the
next cell in that column automatically moves into the empty cell (C2 on sheet
2).

Assing
D E
11 Name Jones
12 First name Richard
13 Country Germany
14 Age 28

gives

Sheet 2
A B C
D
1 Smith Michael UK 26
2 Brown Susan Germany 21
3 Jones Richard 28

I either need to put a 'space' as a place holder in the empty cell (Sheet 1
E13) thus making it think there is something in that cell or format Sheet 2
so that any 'empty' cells are filled with a 'blank' placeholder.
Hope this is clear and that someone can help.
Thanks for a brilliant forum
RG