Results 1 to 7 of 7

Need help transposing Rows into 3 equal columns

Threaded View

Onenguyen Need help transposing Rows... 10-06-2010, 09:04 AM
MickG Re: Need help transposing... 10-06-2010, 09:36 AM
Onenguyen Re: Need help transposing... 10-06-2010, 09:50 AM
Onenguyen Re: Need help transposing... 10-06-2010, 10:09 AM
MickG Re: Need help transposing... 10-06-2010, 10:19 AM
Onenguyen Re: Need help transposing... 10-06-2010, 10:52 AM
Marcol Re: Need help transposing... 10-06-2010, 10:39 AM
  1. #1
    Registered User
    Join Date
    10-06-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Need help transposing Rows into 3 equal columns

    Hello everyone. I am new to this site and I have been reviewing some great post from the members and admins here. I hope you're able to help me with my problem.

    I have created a batch file that automatically creates a directory listing of any folder that I choose. I have made it so that it saves the listing as a csv and opens the file in excel.

    I am getting stuck because I need to be able to break that list down into 3 equal columns.

    Ex:

    a
    b
    c
    d
    e
    f

    into: a b c
    d e f

    I have tried to transpose but it spreads the list completely over the total amount of columns. Is there anyway to limit the range to 3 columns?

    Thank you again for your help!
    Last edited by Onenguyen; 10-06-2010 at 01:48 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1