Hello,
I'm experimenting with Google forms to allow others to book appointments with me. The data comes in from the forms format and is visually messy. I am trying to reorganise to get 'week view' with the names of people who are booked in at times of the week.
I would love to attach the file but it wont upload. Picture below - how do i get the appropriate names to appear in the yellow boxes below?
An easy way to do it is by inserting a fresh column, joining the time and day together using "&" using Vlookup. Simple. However due to the way google forms inserts each new entry across the whole line it then put a blank into that manual column so that cant be the answer.
I might be being daft - but any help wold be most appreciated!
Thanks
Ali
Diary Test.PNG
Bookmarks