Forum Discussion
converting data from table to list
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
I'm not sure what you are asking for. Also: Which version of Excel are you using?
hi,
I using 2010 version. I had attached a file shows how do I want the data look like
thank u very much for replying
- Can you install software on your system? With the (free) Powerquery add-in this is fairly easy.
thank you very much JKPieterse
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?
FWIW, even your final result can also be thought of as a table; a table with only two columns.
