Pivot Table or Something!

L

liamsdad

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 |
+-------------------------------------------------------------------+
 
M

mrice

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?
 

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

Pivot Table or something? 1
converting ascii csv to .txt for financial data 1
Inserting pictures then sorting 2
Ongoing Pivot Table Issue 2
Is this a challenging Pivot Table question? 2
Why won't my Pivot Tables recognise new data? 3
Pivot table question 4
Creating auto Updating Pivot Table linked to external data. 1

Top