make new table

S

sotiris_s

i have the follow problem,
i have a table like this in excel worksheet... i have in collums the number of the days of one month 1,2...31, each day have / occupies 3 different collums beneath with values and the same patern for all the days, the problem is that i don't have all the fields filled with numbers but some, now i want to collect those numbers and make a new table that contains the numbers...... how i can do it?
(at the A collum every row have a different name)
i don't know how to describe it better but for simplicity for each row i want to have the values of every of the 3 collums gothered in one comact table!

Thank you very much
 
K

Ken

It sounds like you want to use the advanced filter command, however it's difficilt to tell from your description. Perhaps you can type a small sample here so we get a better picture of what you have.
 
Top