two interesting questions

  • Thread starter Thread starter ankud1
  • Start date Start date
A

ankud1

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
 
hello everyone

plz let me know if i havenot defined this problem well
wil try to frme it in other way

many thanx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

equal size columns [same no. of rows] 3
missing data in columns[empty cells] 9
Excel Help to copy information from one row at a time to another sheet 1
convert columns to rows 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Transpose?? 6
Import multiple workbooks to current workbook in specified row number 0
Find a value in a sheet and replace it with another value if it matches 8

Back
Top