Thank you for that it has worked well. I have one more question though, how do I sort this result table by say the name or any of the fields...

• This reply was modified 9 months ago by  scott@lucsam.com.

Thanks that worked for me!

Hi there are in this example a max number of sessions of 8. There are multiple rows per session. So I am looking for each row to be the row...

Hi yes SQL

I can transpose it manually in another sheet