<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v = "urn:schemas-microsoft-com:vml" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word" xmlns:x = "urn:schemas-microsoft-com:office:excel" xmlns:p = "urn:schemas-microsoft-com:office:powerpoint" xmlns:a = "urn:schemas-microsoft-com:office:access" xmlns:dt = "uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s = "uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs = "urn:schemas-microsoft-com:rowset" xmlns:z = "#RowsetSchema" xmlns:b = "urn:schemas-microsoft-com:office:publisher" xmlns:ss = "urn:schemas-microsoft-com:office:spreadsheet" xmlns:c = "urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc = "urn:schemas-microsoft-com:office:odc" xmlns:oa = "urn:schemas-microsoft-com:office:activation" xmlns:html = "http://www.w3.org/TR/REC-html40" xmlns:q = "http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc = "http://microsoft.com/officenet/conferencing" XMLNS:D = "DAV:" XMLNS:Repl = "http://schemas.microsoft.com/repl/" xmlns:mt = "http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2 = "http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda = "http://www.passport.com/NameSpace.xsd" xmlns:ois = "http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir = "http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds = "http://www.w3.org/2000/09/xmldsig#" xmlns:dsp = "http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc = "http://schemas.microsoft.com/data/udc" xmlns:xsd = "http://www.w3.org/2001/XMLSchema" xmlns:sub = "http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec = "http://www.w3.org/2001/04/xmlenc#" xmlns:sp = "http://schemas.microsoft.com/sharepoint/" xmlns:sps = "http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs = "http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf = "http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p = "http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf = "http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss = "http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi = "http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi = "http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver = "http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m = "http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels = "http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp = "http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t = "http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m = "http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl = "http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl = "http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" XMLNS:Z = "urn:schemas-microsoft-com:" xmlns:st = ""><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16625">
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Franklin Gothic Medium";
panose-1:2 11 6 3 2 1 2 2 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:"Franklin Gothic Book";
panose-1:2 11 5 3 2 1 2 2 2 4;}
@font-face
{font-family:"Franklin Gothic Demi";
panose-1:2 11 7 3 2 1 2 2 2 4;}
@font-face
{font-family:a;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</STYLE>
</HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 12pt Arial" lang=EN-US link=blue vLink=purple>
<DIV>Here are a couple of approaches that will come close to what you are after:</DIV>
<DIV> </DIV>
<DIV>SELECT STUDENTS SAMPLE<BR>DOWNLOAD STUDENTS \</DIV>
<DIV> STU.NAME \</DIV>
<DIV> STU.TERMS NUM.VALUES ALL VALUE.SEPARATOR '<br>' \</DIV>
<DIV> FORMAT HTML \</DIV>
<DIV> FILE ...</DIV>
<DIV> </DIV>
<DIV>or</DIV>
<DIV> </DIV>
<DIV>
<DIV>SELECT STUDENTS SAMPLE<BR>DOWNLOAD STUDENTS \</DIV>
<DIV> STU.NAME \</DIV>
<DIV> STU.TERMS HTML.ROW 'valign="top"' NUM.VALUES ALL VALUE.SEPARATOR '<br>' \</DIV>
<DIV> FORMAT HTML \</DIV>
<DIV> FILE ...</DIV></DIV>
<DIV> </DIV>
<DIV>or</DIV>
<DIV><BR>SELECT STUDENTS SAMPLE<BR>SELECT STUDENTS BY @ID BY.EXP STU.TERMS<BR>DOWNLOAD STUDENTS \</DIV>
<DIV> BY.EXP STU.TERMS \</DIV>
<DIV> STU.NAME \</DIV>
<DIV> STU.TERMS \</DIV>
<DIV> FORMAT TAB \</DIV>
<DIV> FILE ...<BR></DIV>
<DIV>The first two approaches will stack the terms vertically in the second column. The second approach forces Excel to place the student names at the top of each cell rather than at the bottom. (At least in my copy of Excel 2010, the names get placed at the bottom of each cell by default.)</DIV>
<DIV> </DIV>
<DIV>The third approach will place each term on a separate line...but the student name will be repeated on each line.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT face=Arial>Dave Rotman</FONT></DIV>
<DIV><FONT face=Arial>Associate Vice President for Technology<BR>Chief Information Officer</FONT></DIV>
<DIV><FONT face=Arial>Cedarville University<BR>251 N. Main Street<BR>Cedarville, OH 45314<BR>rotmand@cedarville.edu<BR>voice 937-766-7905<BR>fax 937-766-8819</FONT></DIV>
<DIV> </DIV><BR><BR>>>> On 9/17/2010 at 1:18 PM, in message <FA49C06155F2244C8DE3593C3AA2A52E097E0072@RCG2MAIL.mascorcg.net>, "Robert D. Varju" <Robert.Varju@mascocabinetry.com> wrote:<BR></DIV>
<TABLE style="MARGIN: 0px 0px 0px 15px; FONT-SIZE: 1em" border=0 bgColor=#f3f3f3>
<TBODY>
<TR>
<TD>
<DIV style="BORDER-LEFT: #050505 1px solid; PADDING-LEFT: 7px">
<DIV class=WordSection1>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Perhaps I am missing something obvious.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">I wish to download a TAB formatted file (for use in a spreadsheet) with MV.ORIENTATION VERTICAL. The desired output is that of the FORMAT FIXED display. The spreadsheet would appear as follows:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<TABLE style="WIDTH: 122pt; BORDER-COLLAPSE: collapse; MARGIN-LEFT: -0.75pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=163>
<TBODY>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">Harris, Amy<o:p></o:p></SPAN></P></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">1998FA<o:p></o:p></SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">1999G1<o:p></o:p></SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">1999SP<o:p></o:p></SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">2000FA<o:p></o:p></SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">Jones, Thomas<o:p></o:p></SPAN></P></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">1997SP<o:p></o:p></SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black">2002FA<o:p></o:p></SPAN></P></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap>
<P class=MsoNormal><SPAN style="COLOR: black"><o:p> </o:p></SPAN></P></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap></TD></TR>
<TR style="HEIGHT: 15pt">
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 74pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=99 noWrap></TD>
<TD style="PADDING-BOTTOM: 0in; PADDING-LEFT: 5.4pt; WIDTH: 48pt; PADDING-RIGHT: 5.4pt; HEIGHT: 15pt; PADDING-TOP: 0in" vAlign=bottom width=64 noWrap></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Whenever I use the FORMAT TAB option, the output spreads the MV attribute horizontally, not vertically. Please advise.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'">Regards,<o:p></o:p></SPAN></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'"><o:p> </o:p></SPAN></B></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'; COLOR: #0070c0">Robert D. Varju<o:p></o:p></SPAN></B></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt">Sr. Programmer Analyst I - Retail Operations /Costing<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Demi','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt">Masco Cabinetry<o:p></o:p></SPAN></P>
<P class=MsoNormal><U><SPAN style="FONT-FAMILY: 'Franklin Gothic Demi','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt"><A href="mailto:laura.jones@mascocabinetry.com"><SPAN style="COLOR: black">robert.varju@mascocabinetry.com</SPAN></A></SPAN></U><SPAN style="FONT-FAMILY: 'Franklin Gothic Demi','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt">15535 South State Ave. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt">Middlefield, OH 44062 <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt">tel 440.632.3806 <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Franklin Gothic Book','sans-serif'; COLOR: black; FONT-SIZE: 9.5pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'; COLOR: #5f497a">KraftMaid</SPAN></B><SUP><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'; COLOR: #5f497a; FONT-SIZE: 16pt">®</SPAN></SUP><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'">|<B><SPAN style="COLOR: #804000">Quality</SPAN></B><SPAN style="COLOR: #804000"> Cabinets</SPAN></SPAN><SUP><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'; COLOR: #804000; FONT-SIZE: 16pt">®</SPAN></SUP><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'">|</SPAN><B><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: red">Merillat</SPAN></B><B><SUP><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'; COLOR: red; FONT-SIZE: 16pt">®</SPAN></SUP></B><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'">|<B><SPAN style="COLOR: black">DENOVA</SPAN></B></SPAN><SUP><SPAN style="FONT-FAMILY: 'Franklin Gothic Medium','sans-serif'; COLOR: black; FONT-SIZE: 16pt">®</SPAN></SUP><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #1f497d; FONT-SIZE: 12pt"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: Webdings; COLOR: #007f00">P </SPAN><SPAN style="FONT-FAMILY: a; COLOR: #007f00">Please consider the environment before printing this e-mail.</SPAN><SPAN style="COLOR: #3366ff"><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><o:p> </o:p></P></DIV></DIV></TD></TR></TBODY></TABLE></BODY></HTML>