Need exprt advice to transpose data. Simple copy paste take too much time.

pedie · Jun 8, 2015

Hi everyone, i have a huge data that i recieve weekly and need to organise them everytime.
takes too much time when using for loop with copy and paste.

i have 2 tables. i table is sample raw data format and the other is output 'm expecting.
Please help me out.

Thanks alot in advance,
Pedie
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns

="urn:schemas-microsoft-com

ffice

ffice" xmlns:w="urn:schemas-microsoft-com

ffice:word" xmlns:x="urn:schemas-microsoft-com

ffice:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head>****** http-equiv=Content-Type content="text/html; charset=us-ascii">****** name=Generator content="Microsoft Word 14 (filtered medium)"><style id="Sheet1_4113_Styles"><!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0079C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#009A3D;
text-decoration:underline;}
p.xl154113, li.xl154113, div.xl154113
{mso-style-name:xl154113;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:10.0pt;
font-family:"Arial","sans-serif";
color:black;}
p.xl634113, li.xl634113, div.xl634113
{mso-style-name:xl634113;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
border:none;
padding:0in;
font-size:10.0pt;
font-family:"Arial","sans-serif";
color:black;}
p.xl644113, li.xl644113, div.xl644113
{mso-style-name:xl644113;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
border:none;
padding:0in;
font-size:10.0pt;
font-family:"Arial","sans-serif";
color:black;}
p.xl654113, li.xl654113, div.xl654113
{mso-style-name:xl654113;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
border:none;
padding:0in;
font-size:10.0pt;
font-family:"Arial","sans-serif";
color:black;}
p.xl664113, li.xl664113, div.xl664113
{mso-style-name:xl664113;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
border:none;
padding:0in;
font-size:10.0pt;
font-family:"Arial","sans-serif";
color:black;}
span.EmailStyle22
{mso-style-type

ersonal-compose;
font-family:"Times New Roman","serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link="#0079C1" vlink="#009A3D"><div class=WordSection1> <o

></o

><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=875 style='width:656.0pt;border-collapse:collapse'><tr style='height:12.75pt'><td width=95 nowrap valign=bottom style='width:71.0pt;border:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> <o

></o

></td><td width=83 nowrap valign=bottom style='width:62.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EXP<o

></o

></td><td width=83 nowrap valign=bottom style='width:62.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EXP<o

></o

></td><td width=83 nowrap valign=bottom style='width:62.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EXP<o

></o

></td><td width=83 nowrap valign=bottom style='width:62.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EXP<o

></o

></td><td width=83 nowrap valign=bottom style='width:62.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EXP<o

></o

></td><td width=83 nowrap valign=bottom style='width:62.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EXP<o

></o

></td><td width=64 nowrap valign=bottom style='width:48.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td width=75 nowrap valign=bottom style='width:56.0pt;border:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>date<o

></o

></td><td width=75 nowrap valign=bottom style='width:56.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>emp_<o

></o

></td><td width=71 nowrap valign=bottom style='width:53.0pt;border:solid windowtext 1.0pt;border-left:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>exp<o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>Date<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_1<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_2<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_3<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_4<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_5<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_6<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/1/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_1<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 7,207.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/1/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,207.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,792.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,371.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,973.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,295.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,642.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/1/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_2<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 1,792.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/2/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,485.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,509.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,144.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,311.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,903.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,595.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/1/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_3<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 4,371.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/3/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,301.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,487.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,423.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,295.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,379.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,445.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/1/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_4<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 1,973.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/4/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,095.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,794.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,989.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,835.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,983.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,129.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/1/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_5<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 4,295.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/5/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,491.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$428.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,227.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$362.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,819.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,336.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/1/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_6<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 6,642.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/6/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,775.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$785.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,910.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,730.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,606.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$347.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/2/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_1<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 8,485.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/7/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,940.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,814.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,916.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,496.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,659.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,506.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/2/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_2<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 5,509.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/8/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,529.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,265.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,189.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$859.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,164.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,073.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/2/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_3<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 8,144.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/9/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,999.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,435.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,941.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,132.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,918.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$472.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/2/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_4<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 2,311.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/10/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,070.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,756.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,605.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,901.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,588.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,662.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/2/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_5<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 7,903.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/11/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,350.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,855.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,060.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,829.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$68.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,141.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/2/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>EMP_6<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'> 7,595.00 <o

></o

></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/12/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,463.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,672.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,330.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,987.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,922.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,238.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/13/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,182.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,554.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,298.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,681.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,968.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,311.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/14/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,576.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$240.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$405.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,991.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$812.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,862.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/15/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,277.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,788.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$967.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,402.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,218.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,805.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/16/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,865.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$605.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,428.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,540.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,645.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,485.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/17/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,347.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,551.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,690.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$773.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,362.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,162.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/18/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,895.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,029.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,288.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,200.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$932.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,156.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/19/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,705.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$44.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,308.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,928.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,125.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,821.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/20/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,309.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,675.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$818.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,566.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,411.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$747.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/21/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$136.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,751.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,579.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,117.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$930.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,167.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/22/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,217.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,414.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,736.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,639.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$582.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,223.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/23/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,690.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,910.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$5,224.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$2,964.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,709.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,912.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/24/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,440.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,088.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,838.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,079.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$1,849.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$755.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/25/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,183.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,628.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,884.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,559.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$773.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$7,181.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='height:12.75pt'><td nowrap valign=bottom style='border:solid windowtext 1.0pt;border-top:none;padding:.75pt .75pt 0in .75pt;height:12.75pt'>1/26/2015<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$4,723.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$922.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$6,173.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,122.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$8,760.00<o

></o

></td><td nowrap valign=bottom style='border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:.75pt .75pt 0in .75pt;height:12.75pt'>$3,805.00<o

></o

></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td><td nowrap valign=bottom style='padding:.75pt .75pt 0in .75pt;height:12.75pt'></td></tr><tr style='display:none'><td width=95 style='width:71.0pt;padding:0in 0in 0in 0in'></td><td width=83 style='width:62.0pt;padding:0in 0in 0in 0in'></td><td width=83 style='width:62.0pt;padding:0in 0in 0in 0in'></td><td width=83 style='width:62.0pt;padding:0in 0in 0in 0in'></td><td width=83 style='width:62.0pt;padding:0in 0in 0in 0in'></td><td width=83 style='width:62.0pt;padding:0in 0in 0in 0in'></td><td width=83 style='width:62.0pt;padding:0in 0in 0in 0in'></td><td width=64 style='width:48.0pt;padding:0in 0in 0in 0in'></td><td width=75 style='width:56.0pt;padding:0in 0in 0in 0in'></td><td width=75 style='width:56.0pt;padding:0in 0in 0in 0in'></td><td width=71 style='width:53.0pt;padding:0in 0in 0in 0in'></td></tr></table><o

> </o

></div></body></html>

RonB1111 · Jun 8, 2015

Do a Reverse Pivot Table:
1. Press these 3 keys sequentially (not at the same time): Alt D P
2, In the Pivot Table Wizard box that pops up, click "Multiple Consolidation Ranges", and then click "Next"
3. Click "I will create the page fields", and then click "Next"
4. Select your data range so it will fill in the top box (or type the range in the top box), then click "Add", then click "Finish"
5. A pivot table will appear on a new tab - double click the Grand Total Amount (ie: the number in the last row & column of the pivot table)
6. Your requested answer will now appear on a new tab that automatically pops up.

pedie · Jun 8, 2015

Ron thanks for helping .
'm not getting the right layout after following this.

i want to transpose employee names and exp in rows with dates.

Thanks again.

pedie · Jun 8, 2015

ok i think i get what you are saying. Is there a way we can do this with macro?

MickG · Jun 8, 2015

Try this:-
Result start "M1"
NB:- Assumed that your Actual Dates start "A3"

Code:

[COLOR="Navy"]Sub[/COLOR] MG08Jun36
[COLOR="Navy"]Dim[/COLOR] Ray [COLOR="Navy"]As[/COLOR] Variant, Rw [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] Ac [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] c [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
Ray = ActiveSheet.Range("A1").CurrentRegion
ReDim nRay(1 To UBound(Ray, 1) * UBound(Ray, 2), 1 To 3)
nRay(1, 1) = "Date": nRay(1, 2) = "EMP": nRay(1, 3) = "EXP"
c = 1
[COLOR="Navy"]For[/COLOR] Rw = 3 To UBound(Ray, 1)
    [COLOR="Navy"]For[/COLOR] Ac = 2 To UBound(Ray, 2)
        c = c + 1
        nRay(c, 1) = Ray(Rw, 1): nRay(c, 2) = Ray(2, Ac): nRay(c, 3) = Ray(Rw, Ac)
    [COLOR="Navy"]Next[/COLOR] Ac
[COLOR="Navy"]Next[/COLOR] Rw
Range("M1").Resize(c, 3) = nRay
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

RonB1111 · Jun 8, 2015

Suggest trying to "record" it as a macro while you're doing the key-strokes. (ie: On the Developer Ribbon, click "Record Macro", then do the process I described, then on the Developer Ribbon, click "Stop Recording"

pedie · Jun 8, 2015

Thanks Mick. it was great!

Ron, thanks for pivot/consolidation trick. i have not used this yet but i think this is idle for huge data. I'll post back in near future after i put the code together

Thanks to you GUYS!!!

Pedie

Code:

[/FONT][FONT=courier new]Option Explicit[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]Sub MG08Jun36()[/FONT]
[FONT=courier new]Dim Ray As Variant, Rw As Long, Ac As Long, c As Long[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]Ray = ActiveSheet.Range("A1").CurrentRegion[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]'assign array by excel range[/FONT]
[FONT=courier new]ReDim nRay(1 To UBound(Ray, 1) * UBound(Ray, 2), 1 To 3)[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]'heading[/FONT]
[FONT=courier new]nRay(1, 1) = "Date": nRay(1, 2) = "EMP": nRay(1, 3) = "EXP"[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]c = 1[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]'store all data in array;[/FONT]
[FONT=courier new]For Rw = 3 To UBound(Ray, 1)[/FONT]
[FONT=courier new]    For Ac = 2 To UBound(Ray, 2)[/FONT]
[FONT=courier new]        c = c + 1[/FONT]
[FONT=courier new]        [/FONT]
[FONT=courier new]        nRay(c, 1) = Ray(Rw, 1)[/FONT]
[FONT=courier new]        nRay(c, 2) = Ray(2, Ac)[/FONT]
[FONT=courier new]        nRay(c, 3) = Ray(Rw, Ac)[/FONT]
[FONT=courier new]        [/FONT]
[FONT=courier new]    Next Ac[/FONT]
[FONT=courier new]Next Rw[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]'print array data;[/FONT]
[FONT=courier new]Range("M1").Resize(c, 3) = nRay[/FONT]
[FONT=courier new]
[/FONT]
[FONT=courier new]End Sub

Need exprt advice to transpose data. Simple copy paste take too much time.

pedie

Well-known Member

Excel Facts

RonB1111

Well-known Member

pedie

Well-known Member

pedie

Well-known Member

MickG

MrExcel MVP

RonB1111

Well-known Member

pedie

Well-known Member

Similar threads

Forum statistics

Share this page

Need exprt advice to transpose data. Simple copy paste take too much time.

pedie

Well-known Member

Excel Facts

RonB1111

Well-known Member

pedie

Well-known Member

pedie

Well-known Member

MickG

MrExcel MVP

RonB1111

Well-known Member

pedie

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock