+ Reply to Thread
Results 1 to 5 of 5

macro to change rows to columns

Hybrid View

  1. #1
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: macro to change rows to columns

    posting txt file would be helpful

  2. #2
    Registered User
    Join Date
    02-04-2011
    Location
    Uhmurika
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: macro to change rows to columns

    This is an example of the form template I am using from word and the .txt. This example is just 3 pages and I need to import it into excel with each page being its own row.

    I know I can just save one page at a time but i may have up to 1000+ pages eventually and to save each file individually would be a big hassle.

    Every page has 20 form values. The particular word doc I'm trying to import atm is 84 pages. So that is 1680 cells occupied all in one row. I could scroll every 20 cells and cut n paste to the next row, but hopefully there is a better way.

    Thanks
    Attached Files Attached Files
    Last edited by faptronic; 02-07-2011 at 11:04 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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