Pivot Table or Something!
 

I have a supplier that has switched forecasting formats and now send me
a CSV file that is impossible to format into usable data. Is there
anyway to convert this file so that I can have all the data including
the dates in a pivot format or something like it for ease of
useability?


+-------------------------------------------------------------------+
|Filename: Example.txt |
|Download: http://www.excelforum.com/attachment.php?postid=5004 |
+-------------------------------------------------------------------+

--
liamsdad
------------------------------------------------------------------------
liamsdad's Profile: http://www.excelforum.com/member.php...o&userid=35388
View this thread: http://www.excelforum.com/showthread...hreadid=560112

Pivot Table or Something!
 

Not quite sure what you want here but I'll assume that you've tried
changing the .txt to .csv or alternatively using text to columns?


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560112