converting data from table to list

Copper Contributor

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 

5 Replies
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 

 

@Jan Karel Pieterse 

@Yousuf_A 

 

A couple more questions:

  1. 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?
  2. 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?
  3. 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.

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

thank you very much @Jan Karel Pieterse