hello everyone

i want to ask two interesting questions tried to slove them but as i m
novice so havnt solved so far

1] first problem is i have data in [n] columns {varaible no. of
columns} the data in each is of different length/diff number of rows
are present

i want to make all coulumns are of same size

say if 1 column has data in 15 rows n another column hav data in 6
rows [so i want to copy data of 6 row in all the rows upto 15] and
some other column hav data in 10 rows ..[so i want to copy data of 6
row in all the coumns upto 15] so want them to make equal length

2] Second Problem, i have data in [n] columns ,

one column data set have values in all rows [ say in row 1 to row 15]
while
its adjacent column2 have some missing data [say in row 6 no data ]
so i want to chk from column 1 if in the 6th row data is present so
copy the data in column2 from row7 to row6

likewise in case off all columns { columns and rows are variable
depends on data set]

hope some of u find time to help me out
waitng for ur reply

many thanx in advance