rows as columns with custom names
I have disk information of 100 servers in format like below: Servername Drive FreeDiskSpace(GB) Size(GB) Server1 C: 4 60 Server1 D: 70 200 I don't want the servername to appear twice or thrice in the row. Instead I want information for one server in a single row, like below: Servername C: FreeSpace(GB) C: Size(GB) D: FreeSpace(GB) D: Size(GB) Server1 4 60 70 200 Like this there are 100 servers. How can I achieve this in excel?