Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have data that looks like this
Group Eyes Hair Grade 1 Bk Bk 4 1 Bl Bk 6 1 Bk Bk 4 2 Br Br 4 2 Br Br 7 3 Hz Br 6 and so forth where there aren't necessarily the same number of individuals in each group as in the example above (group 1 n=3, group 2 n=2, group 3 n=1) I want to restructure it. It's easy to do in SPSS, but I would like to do it in Excel. It should look like this Group Feature Result 1 Eyes Bk 1 Eyes Bl 1 Eyes Bk 1 Hair Bk 1 Hair Bk 1 Hair Bk 1 Grade 4 1 Grade 6 1 Grade 4 2 Eyes Br 2 Eyes Br 2 Hair Br 2 Hair Br 2 Grade 4 2 Grade 7 3 Eyes Hz 3 Hair Br 3 Grade 6 Any ideas? Thanks in advance, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
Restructure text order | Excel Discussion (Misc queries) | |||
Make Excel 2000 print long narrow list "snake" on wide paper? | Excel Discussion (Misc queries) | |||
Please help restructure this code | Excel Programming |