Hi everyone, new user here
I need some way of making the data in my txt file transpose into an excel file in a particular way, it is a huge data set I am working with and to do it by hand would be very tedious. The picture below shows you what I need. Basically the numbers in the txt file which run horizontally in columns needs to run horizontally in excel.
Thank you for any help given, really appreciate it
James
Last edited by romperstomper; 11-24-2011 at 11:22 AM.
It will be better if you attach a sample text file and a excel file (if you already have started creating it) instead of the jpg file.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Ah okay, here you go
Hi,
Please find attached the excel file.
Procedure :
- External Data > from text > Import the file text > Text import wizard
- Step 1 Fixed width > Next
- Step 2 Next
- Step 3 Standard format > End
Result in Data Sheet
Best regards
Hi, sorry but I think you or I may have misunderstood. I want the results in excel to be one continous row across, not in columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks