Hello,
I have spent a lot of time museing over my problem and i have looked at a number of questions which are similar to mine. However, none have answered it and I do wonder if I am going about this the wrong way.
I am a teacher and I use google agenda to plan my lessons. Once the course is complete i create a report of my agenda using GTimeReport. it looks like this ( What i want to achieve is to use this form as mail merge data to import what i have written to a specific word doc we have to use.)
column K is what i am struggling with. each text you see in K needs to be a column header. The text that would be below each of these is where i write my details, and these details would be therefore under each column header.
I have so far merged the cells into one, thinking i could then split the cells when it arrives at each "header" and then take this data into a new column.
1. I cant find a code ( or create one) that will do this
2. move this data into a column. ( i think i could do this once the data is split)
3. is this even the right way to go ????????
thankyou in advance for your help.
I have spent a lot of time museing over my problem and i have looked at a number of questions which are similar to mine. However, none have answered it and I do wonder if I am going about this the wrong way.
I am a teacher and I use google agenda to plan my lessons. Once the course is complete i create a report of my agenda using GTimeReport. it looks like this ( What i want to achieve is to use this form as mail merge data to import what i have written to a specific word doc we have to use.)
I have so far merged the cells into one, thinking i could then split the cells when it arrives at each "header" and then take this data into a new column.
1. I cant find a code ( or create one) that will do this
2. move this data into a column. ( i think i could do this once the data is split)
3. is this even the right way to go ????????
thankyou in advance for your help.