Hi guys, First of all, this is not a crucial issue. In fact, it is really for idle minds :) I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting) 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: Name Date Dept Jina 1 12.12.12 Dept 1 Jina 2 12.12.12 Dept 3 Jina 3 13.12.12 Dept 5 ... etc Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?) Name: Date: Dept Jina 1::12.12.12:: Dept 1 Extra marks if you can do it only using excel formulas Mr. Lawi
You can try saving it as a CSV file, then working on it from there will be easier/ On 16 March 2012 13:07, mail2lawi <mail2lawi@gmail.com> wrote:
Hi guys,
First of all, this is not a crucial issue. In fact, it is really for idle minds :)
I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting)
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:
Name Date Dept Jina 1 12.12.12 Dept 1 Jina 2 12.12.12 Dept 3 Jina 3 13.12.12 Dept 5 ... etc
Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?) Name: Date: Dept Jina 1::12.12.12:: Dept 1
Extra marks if you can do it only using excel formulas
Mr. Lawi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
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. 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 On Fri, Mar 16, 2012 at 11:14 AM, Vincent Wayodi <wayodi@gmail.com> wrote:
You can try saving it as a CSV file, then working on it from there will be easier/
On 16 March 2012 13:07, mail2lawi <mail2lawi@gmail.com> wrote:
Hi guys,
First of all, this is not a crucial issue. In fact, it is really for idle minds :)
I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting)
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:
Name Date Dept Jina 1 12.12.12 Dept 1 Jina 2 12.12.12 Dept 3 Jina 3 13.12.12 Dept 5 ... etc
Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?) Name: Date: Dept Jina 1::12.12.12:: Dept 1
Extra marks if you can do it only using excel formulas
Mr. Lawi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
try pasting to Notepad first, then save as a csv file, before opening to excel. On 16 March 2012 13:21, mail2lawi <mail2lawi@gmail.com> wrote:
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.
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
On Fri, Mar 16, 2012 at 11:14 AM, Vincent Wayodi <wayodi@gmail.com> wrote:
You can try saving it as a CSV file, then working on it from there will be easier/
On 16 March 2012 13:07, mail2lawi <mail2lawi@gmail.com> wrote:
Hi guys,
First of all, this is not a crucial issue. In fact, it is really for idle minds :)
I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting)
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:
Name Date Dept Jina 1 12.12.12 Dept 1 Jina 2 12.12.12 Dept 3 Jina 3 13.12.12 Dept 5 ... etc
Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?) Name: Date: Dept Jina 1::12.12.12:: Dept 1
Extra marks if you can do it only using excel formulas
Mr. Lawi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
Use the following Excel macro: Sub tabulate() x = WorksheetFunction.CountA(Range("A:A")) / 3 For i = 1 To x Cells(i, 2).Resize(, 3) = Application.Transpose(Cells((i - 1) * 3 + 1, 1).Resize(3)) Next i End Sub On Fri, Mar 16, 2012 at 1:40 PM, Vincent Wayodi <wayodi@gmail.com> wrote:
try pasting to Notepad first, then save as a csv file, before opening to excel.
On 16 March 2012 13:21, mail2lawi <mail2lawi@gmail.com> wrote:
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.
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
On Fri, Mar 16, 2012 at 11:14 AM, Vincent Wayodi <wayodi@gmail.com>wrote:
You can try saving it as a CSV file, then working on it from there will be easier/
On 16 March 2012 13:07, mail2lawi <mail2lawi@gmail.com> wrote:
Hi guys,
First of all, this is not a crucial issue. In fact, it is really for idle minds :)
I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting)
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:
Name Date Dept Jina 1 12.12.12 Dept 1 Jina 2 12.12.12 Dept 3 Jina 3 13.12.12 Dept 5 ... etc
Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?) Name: Date: Dept Jina 1::12.12.12:: Dept 1
Extra marks if you can do it only using excel formulas
Mr. Lawi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
Found this in MS support. Works perfect. =OFFSET($A$1,(ROW()-1)*3+INT((COLUMN()-3)),MOD(COLUMN()-3,1)) http://support.microsoft.com/kb/214024 On Mon, Mar 19, 2012 at 11:18 AM, Andrew Ouko <andrewouko@gmail.com> wrote:
Use the following Excel macro:
Sub tabulate() x = WorksheetFunction.CountA(Range("A:A")) / 3 For i = 1 To x Cells(i, 2).Resize(, 3) = Application.Transpose(Cells((i - 1) * 3 + 1, 1).Resize(3)) Next i End Sub
On Fri, Mar 16, 2012 at 1:40 PM, Vincent Wayodi <wayodi@gmail.com> wrote:
try pasting to Notepad first, then save as a csv file, before opening to excel.
On 16 March 2012 13:21, mail2lawi <mail2lawi@gmail.com> wrote:
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.
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
On Fri, Mar 16, 2012 at 11:14 AM, Vincent Wayodi <wayodi@gmail.com>wrote:
You can try saving it as a CSV file, then working on it from there will be easier/
On 16 March 2012 13:07, mail2lawi <mail2lawi@gmail.com> wrote:
Hi guys,
First of all, this is not a crucial issue. In fact, it is really for idle minds :)
I have a small email which is supposed to be of a list of employees, their dept and date (of a meeting)
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:
Name Date Dept Jina 1 12.12.12 Dept 1 Jina 2 12.12.12 Dept 3 Jina 3 13.12.12 Dept 5 ... etc
Now, how do I put it in a tabular format preferably in excel (without having to retype or copy/paste?) Name: Date: Dept Jina 1::12.12.12:: Dept 1
Extra marks if you can do it only using excel formulas
Mr. Lawi
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
participants (3)
-
Andrew Ouko -
mail2lawi -
Vincent Wayodi