Spliting Data In Excel

[shyam sundar]

Hi All,

Am having an excel where employee data's are not aligned in proper format. Each employee data are separated by the department code. I want all the data's are to be aligned in a single format. Where the department code comes first. Have attached the sample excel with the desired output.

The employee details may vary in the department for e.g. in the attachment I have given four records for all the departments. This can be 4,5 or even one will be there.

Thanks
Shyam