=========================================================================
Date:         Thu, 13 Jul 2006 02:59:55 -0500
Reply-To:     jmcconnell@Applied-insights.co.uk
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         John McConnell <jmcconnell@APPLIED-INSIGHTS.CO.UK>
Subject:      Re: List Command output
Comments: To: Mark Webb <targetlk@iafrica.com>
Content-Type: text/plain; charset=us-ascii

 Hi Mark

 If you use the Case Summaries option (from memory this is in thenAnalyze>Reports menu and in syntax SUMMARIZE) you get a list inside a pivot table which is the key to Excel compatibility.

 From there you should be able to cut/paste or even export the table to Excel to keep more of the formatting.

 hth

 john

 John McConnell
 Applied Insights


---------- Original Message ----------------------------------
From: Mark Webb <targetlk@iafrica.com>
Reply-To: Mark Webb <targetlk@iafrica.com>
Date:          Thu, 13 Jul 2006 09:28:01 +0200

>Hi all
>I'm using the List Command to list selected respondents and a few variables.
>e.g. List Variables = Name Branch Dept Var1 Var2 Var3.
>
>When I copy & past into Excel all variables listed go into one column.
>How can I get a SPSS output that will export into columns - like for example the Frequencies command ?
>The print command is much the same.
>
>Regards
>
>Mark Webb