For loop output to excel file

UNIX for Beginners Q & A
1

Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help?

The output which I get

Server1 : count
Server2 : count
.
.
.
Server7 : count

The output format which I want in a excel is

Server1   server2     server3 ...... server7
Count       count        count   ......  count

I want this output as columns in excel

2

You could transpose the rows and columns, there are many examples on these forums and import into excel as a csv file

or:
Have you tried the pivot function when pasting in Excel?