converting data in column into rows data

I have data in columns and want to convert them into rows as per the screenshot below.

name field is one example; there are multiple other fields like department and entity should also aligned in out put