converting data from table to list

Question

Please,I need help to convert daily data from table format to list format, so it will be in the correct order by date.I have attach a sample of the data&nbsp;

jkpieterse · Answer

I'm not sure what you are asking for. Also: Which version of Excel are you using?

yousuf_a · Answer

hi,I using 2010 version. I had attached a file shows how do I want the data look like&nbsp;thank u very much for replying&nbsp;&nbsp;JKPieterse&nbsp;

mathetes · Answer

Yousuf_A&nbsp;&nbsp;A couple more questions:How did you get that data in your "desired" example into the form it's in? Can you not just do the same with what's left?That data all is numerical data in text form. Do you want it to stay in text form? If in fact the info in column B is quantity (or some other value) measured in numbers, shouldn't it be stored as numbers?Similarly the dates--is there some compelling reason to keep them as text?&nbsp;FWIW, even your final result can also be thought of as a table; a table with only two columns.

jkpieterse · Answer

Can you install software on your system? With the (free) Powerquery add-in this is fairly easy.

yousuf_a · Answer

thank you very much&nbsp;JKPieterse&nbsp;

Forum Discussion

converting data from table to list

5 Replies

Resources