Transpose Data from Columns to rows

Shell Programming and Scripting
1

Hello. very new to shell scripting and would like to know if anyone could help me.

I have data thats being pulled into a txt file and currently have to manually transpose the data which is taking a long time to do.

here is what the data looks like.

Server1 -- Date -- Other -- value
Server1 -- Date -- Other -- value
Server1 -- Date -- Other -- value
Server1 -- Date -- Other -- value

dates range the entire month
What i need it to look like is:

SERVERS ---  Date --- date --- date --- date
server1         value     value     value      value
server1         value     value     value      value
server1         value     value     value      value

If any one could help that would be great!

2

I am going to presume the data is sorted.

start="Y"
prevserver=""
while read server date other value
do
if [ [ "a$server" != "a$prevserver" ]
then 
    prevserver=$server
    if [ "$start"  = "Y "]
   then
       Start="N"
    else
      echo "\n" 
   fi
 echo $prevserver $value "\c"
fi
echo " " $value "\c"
done<sortedinputfile
3

so that should place the data from this:

server3 12/1/2011-10:03 OTHER INFO 4.7
server4 12/1/2011-10:03 OTHER INFO 5.3
server5 12/1/2011-10:03 OTHER INFO 1.1
server6 12/1/2011-10:03 OTHER INFO 6.3

to this:

      12/1/2011 12/2/2011
server3  4.7     3.4
server4  5.3     3.6
server5  1.1     0.9
server6  6.3     5.6
4

Close, your input file contains more fields than you specified.

server4 12/1/2011-10:03 OTHER INFO 5.3

is five fields using white space as the field separator.
So the read statement should change to

read server datetime other info value

I didn't code for the the heading line.
If the data is not sorted, sort first with

sort <inputfile >sortedinputfile
5

sorry the other info is in the same cell when u open it.

6

how would i get the script to sort the data to something like this and output to a new file:

      12/1/2011 12/2/2011
server3  4.7     3.4
server4  5.3     3.6
server5  1.1     0.9
server6  6.3     5.6

Keep in mind there are at least 30 days worth of data for each server.

7

Are you opening the file in Excel or something similar, the word "cell" is not generally used in unix/linux.
If you are opening the file in Excel, then only save the servername and value columns to a text file.
Can you show us an exact sample of the data?

8

attached is an excel file of what i have to have the info look like.
The first 3 columns is how the information is saved to file.
The section to the side is what i have to manually input. Thats the part i want to have automated.

The other way i could pull that data is having it pull all of one server for the month then do the second etc etc.

Thanks