Merge column values in one row based on common key

We need a vba script to get the desired output for data in the given input format


Key -----Val1----- Val2----- Val3
Key1-----a1
Key1------------- b1
Key1------------------------c1
Key2-----a2
Key2------------- b2
Key2------------------------c2
Key3-----a3
Key3------------- b3
Key3------------------------c3




Desired Ouput:
---------------
Key Val1 Val2 Val3
Key1 a1 b1 c1
Key2 a2 b2 c2
Key3 a3 b3 c3

The same needs to be applied for data around 50 sheets in the same excel. Also, the number of columns for Val1, Val2, etc goes beyond 20 in many of the sheets. Kindly post your suggestion to automate the same.

Thanks,