I don't see any way to assign display logic for the individual rows within the side by side table. Am I missing something?
That would be great, but we will need to be able to re-parse the data frequently, so I think excel will work best for us. Thank you though!
Thank you! Your answer led me to find a macro online that is clearly heading in the right direction, but it is not reading the groups correctly. (It is reading them as 1,2,3,1,2,3 when the data is 1,1,1,2,2,2,3,3,3) I may be able to get some help at the office to review/revise the macro in VBA, but do you by chance know of a good resource for sample macros to do this? We don't have SPSS or R. Here is the macro that is almost right, but not quite. Sub ReOrganize2() 'JBeaucaire (rewritten 3/21/2014) 'Turns row data into columnar data, groups of data merged down together 'Option to copy the header down as a new data cell from each group created Dim wsRAW As Worksheet, wsNEW As Worksheet, ClassNm As Boolean Dim NR As Long, LR As Long, Rw As Long, FirstCol As Long, ColGrps As Long, LastCol As Long, Col As Long 'Confirm raw data is the activesheet onscreen If MsgBox("Reorganize the activesheet?", vbYesNo, "Proceed?") = vbNo Then Exit Sub 'User indicates which column is the first column t
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.