Arrange the rows values into columns

Hi Glen,

Thanks for the formula. My apologies if my message is cofusing. I want to display the sheet 2 appointments in Sheet 1 with respective client and appointments in columns

Thanks,
Satya