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
Bookmarks