I don't think i explained it good enough let me try again.
In Sheet2 I have the following crime data and it could be a couple of
hundred rows
8/1/2005 FALSE INFO TO OFFICER
8/1/2005 N&D/PARAPHERNALIA
8/1/2005 MUNI CODE/SOLICIT W/O PERMIT
8/2/2005 ASSAULT WITH DEADLY WEAPON
8/2/2005 BATTERY/SIMPLE
I am in now back in Sheet1 Cell A1 I want a formula that will read
Sheet2 and Concatenate all the info for the first date like this into
one Cell
FALSE INFO TO OFFICER
N&D/PARAPHERNALIA
MUNI CODE/SOLICIT W/O PERMIT
I will write another formula that will put then data from the next date
into anohter cell untill I have all the data for the month.
I showed her how to do this with a pivot table but she wants it to look
like a calendar.
Thanks Again,
Lenny
|