I have an export format coming over from my hand help device that is coming
over in .csv when i open it up in excel my format is as follows:
date,time,value,shift
date, time,value,shift
date,time,value,shift
date,time value shift

How i need it to come over is this way:
date,time,value,shift[]date,time,value,shift[],date,time,value,shift.......

The[]is the CRLF how can i set the above format up running an excel macro?