make new table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

splitting a cell in to three 4
Formula to count multiple various inputs and create a summary 2
Replace cell value with cell answer 4
Real hard one 7
Sub Total Cost by MFG 2
Matching parts to model numbers 4
Insert row not coping all forumlas 2
Creating Pivot Tables using a CSV file 1

Back
Top