Use the following Excel macro:<br><br>Sub tabulate()<br>x = WorksheetFunction.CountA(Range(&quot;A:A&quot;)) / 3<br>For i = 1 To x<br>Cells(i, 2).Resize(, 3) = Application.Transpose(Cells((i - 1) * 3 + 1, 1).Resize(3))<br>

Next i<br>End Sub<br><br><br><div class="gmail_quote">On Fri, Mar 16, 2012 at 1:40 PM, Vincent Wayodi <span dir="ltr">&lt;<a href="mailto:wayodi@gmail.com">wayodi@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

try pasting to Notepad first, then save as a csv file, before opening to excel.<div class="HOEnZb"><div class="h5"><div><div><br></div><div><br><br><div class="gmail_quote">On 16 March 2012 13:21, mail2lawi <span dir="ltr">&lt;<a href="mailto:mail2lawi@gmail.com" target="_blank">mail2lawi@gmail.com</a>&gt;</span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thats where I am. Already copied it to excel. The data is supposed to be in 3 columns but as in the illustration I gave, its all in one column.<div>


<br></div><div>I want some form of algorithm to create 3 rows (for name, date and dept) and populate the details below those columns. Without having to copy/paste<div><div><br>
<br><div class="gmail_quote">On Fri, Mar 16, 2012 at 11:14 AM, Vincent Wayodi <span dir="ltr">&lt;<a href="mailto:wayodi@gmail.com" target="_blank">wayodi@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">



You can try saving it as a CSV file, then working on it from there will be easier/<div><br><br><div class="gmail_quote"><div><div>On 16 March 2012 13:07, mail2lawi <span dir="ltr">&lt;<a href="mailto:mail2lawi@gmail.com" target="_blank">mail2lawi@gmail.com</a>&gt;</span> wrote:<br>




</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Hi guys,<div><br></div><div>First of all, this is not a crucial issue. In fact, it is really for idle minds :)</div>



<div>
<br></div><div>I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting)</div>
<div><br></div><div>It was supposed to be sent in a tabular format but for some reasons (blame my email client) this is how it appears on my screen:</div><div><br></div><div>Name</div><div>Date</div><div>Dept</div><div>Jina 1</div>





<div>12.12.12</div><div>Dept 1</div><div>Jina 2</div><div>12.12.12</div><div>Dept 3</div><div>Jina 3 </div><div>13.12.12</div><div>Dept 5</div><div>...</div><div>etc</div><div><br></div><div>Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?)</div>





<div>Name: Date: Dept</div><div>Jina 1::12.12.12:: Dept 1</div><div><br></div><div>Extra marks if you can do it only using excel formulas </div><div><br></div><div>Mr. Lawi</div>
<br></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div></div>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>