I have a spreadsheet with 2 sheets (one named master, one named logs). In master, I have created a new column called "Logs" (column I) , where I want to import some data from the logs sheet. In the master spreadsheet column A is called date, and in the logs spreadsheet, column J is also called date, this will be key for the join/match. Also in the logs sheet is a column called "transaction time", which is format dd:mm:yy hh:ss. there are a number of transaction times per date! I wanted to get all the various transaction dates per date into one string of text delimited by ; , i.e. everything on 21/08/2015 in a fomat "21/08/2015 07:00; 21/08/2015 07:35; 21/08/2015 08:35"
and then copy that string of text into the "logs" column in the master spreadsheet!