I have CSV and would like to import in excel table but this excel table is only in one row.
Is there some possibility to show data in rows NOT coloumns?
need urgent help
I enclose my TXT file but when I import this to my excel it will be all in one line. Data records shoud be in rows.
Last edited by toplisek; 06-17-2008 at 12:27 PM.
Okay, I think you're saying it all gets imported into a single row (e.g. 1)?
You'll need to do this after importing:
Import in row . Thus data is from A1 to IV1
Copy your data
Select A2, Paste Special > Transpose data.
Delete original data.
Note, not sure on 2007 but most versions only have 254 columns. Does this cause a problem with your initial import?
ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks