Hello,
I need to convert a .skv file containing three rows into one row with several columns.
The file looks like this:
D1000;286;AR;2
;0; 1
END
And I want it to look like this instead:
D1000 286 AR 2 0 1 END
Can somebody please help me with the the code for this operation?
Regards
Olov
Last edited by Ledarn; 05-29-2013 at 03:55 AM. Reason: Solved!
try this code, if problems attach please the file
Please Login or Register to view this content.
If solved remember to mark Thread as solved
It works excellent when I have one file. I didin´t mention that I have several skv-files that I would like to convert and insert into one excel sheet.
I have a code that imports all the skv-files but I want them to be transposed like your code does.
My current code looks like this:
So I want to have a loop that imports the skv-files, convert them into columns and then add the filename i a new column.Please Login or Register to view this content.
Is that possible?
//Olov
attach a sample file with desired resultPlease Login or Register to view this content.
Thank you!
I tweaked the code a little bit and made it work!
The code that worked the way I wanted to looks like this:
Thank you very much for you help!Please Login or Register to view this content.
//Olov
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks