Arrange the rows values into columns

Hi,

I have a data that contains my clients appointments and one client is having multiple appointments in row (please refer sheet 2). Now I am updating the data in sheet 1 as clients in rows and need to update the appointments in columns.

Please let me know which excel function will work. As of now I am updating manually with transpose function.

Thanks,
Satya