I have data from hundreds of hours of a chat history between myself and a now deceased friend.
The columns are organized into date, screen name and message. When I paste it into word, each message is stacked on top of the other.
I would like for there to be a new row inserted whenever the screename changes, or that is to say, whenever the current "screen name" column is not equal to the "screen name" column immediately before it.
So here is how it looks now:
10/26/2009 TV Hello
10/26/2009 LG How are you
10/26/2009 TV I am fine
10/26/2009 TV How about you
10/26/2009 LG Oh good
10/26/2009 LG I am glad you are well
10/26/2009 LG hahaha
Here is how I need it:
10/26/2009 TV Hello
(SPACE)
10/26/2009 LG How are you
(SPACE)
10/26/2009 TV I am fine
10/26/2009 TV How about you
(SPACE)
10/26/2009 LG Oh good
10/26/2009 LG I am glad you are well
10/26/2009 LG hahaha
Thank you to anyone who can assist!!
The columns are organized into date, screen name and message. When I paste it into word, each message is stacked on top of the other.
I would like for there to be a new row inserted whenever the screename changes, or that is to say, whenever the current "screen name" column is not equal to the "screen name" column immediately before it.
So here is how it looks now:
10/26/2009 TV Hello
10/26/2009 LG How are you
10/26/2009 TV I am fine
10/26/2009 TV How about you
10/26/2009 LG Oh good
10/26/2009 LG I am glad you are well
10/26/2009 LG hahaha
Here is how I need it:
10/26/2009 TV Hello
(SPACE)
10/26/2009 LG How are you
(SPACE)
10/26/2009 TV I am fine
10/26/2009 TV How about you
(SPACE)
10/26/2009 LG Oh good
10/26/2009 LG I am glad you are well
10/26/2009 LG hahaha
Thank you to anyone who can assist!!
Last edited: