Forum Discussion
Help with copying word data to match excel format
Lewis-H thank you but that is the opposite of what I am trying to do. Here are example files, I am trying to copy the info in word and paste it to excel making the way the data is laid out look like it does in excel automatically.
CollinHelpdesk If you are on a recent version of Excel and if your data is really as structured as your example suggests (i.e. NAME, Filed1, Field2, Field3, NAME Filed1, Field2, Field3, etc.) perhaps the attached example will work for you. First copy the list from Word in a separate tab and then use TRANSPOSE and INDIRECT to transpose every group of four rows into four columns. I used two named formulae that calculate the start and end rows for each record "from Word", based on the current row number in "Toby's List" so the final formula becomes easier to read.