Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post transpose column to row in loop

    Dear all

    below id the df -k status of a unix m/c

    Filesystem kbytes used avail capacity Mounted on
    /dev/md/dsk/d10 20655025 13091572 7356903 65% /
    /devices 0 0 0 0% /devices
    ctfs 0 0 0 0% /system/contract
    proc 0 0 0 0% /proc
    mnttab 0 0 0 0% /etc/mnttab
    swap 18472536 1672 18470864 1% /etc/svc/volatile
    objfs 0 0 0 0% /system/object
    fd 0 0 0 0% /dev/fd
    swap 18472520 1656 18470864 1% /tmp
    swap 18495920 25056 18470864 1% /var/run
    swap 18470864 0 18470864 0% /dev/vx/dmp
    swap 18470864 0 18470864 0% /dev/vx/rdmp
    /dev/md/dsk/d106 20655025 4184252 16264223 21% /u01
    /dev/vx/dsk/s-dg/arch 25804343 746863 24541394 3% /arch
    /dev/vx/dsk/s-dg/backup 25804343 4763248 20525009 19% /backup
    /dev/vx/dsk/s-dg/u02 37158356 8437746 27977443 24% /u02
    /dev/vx/dsk/s-dg/u03 25804343 14183873 11104384 57% /u03
    /dev/vx/dsk/s-dg/u04 25804343 10773360 14514897 43% /u04
    /dev/vx/dsk/s-dg/u05 10321884 2796532 7318915 28% /u05
    /dev/vx/dsk/s-dg/u06 10321884 2946591 7272075 29% /u06

    ---------------------<empty record/cell separation>---------------------

    Filesystem kbytes used avail capacity Mounted on
    /dev/md/dsk/d10 20655025 13091572 7356903 65% /
    /devices 0 0 0 0% /devices
    ctfs 0 0 0 0% /system/contract
    proc 0 0 0 0% /proc
    mnttab 0 0 0 0% /etc/mnttab
    swap 18472536 1672 18470864 1% /etc/svc/volatile
    objfs 0 0 0 0% /system/object
    fd 0 0 0 0% /dev/fd
    swap 18472520 1656 18470864 1% /tmp
    swap 18495920 25056 18470864 1% /var/run
    swap 18470864 0 18470864 0% /dev/vx/dmp
    swap 18470864 0 18470864 0% /dev/vx/rdmp
    /dev/md/dsk/d106 20655025 4184252 16264223 21% /u01
    /dev/vx/dsk/s-dg/arch 25804343 746863 24541394 3% /arch
    /dev/vx/dsk/s-dg/backup 25804343 4763248 20525009 19% /backup
    /dev/vx/dsk/s-dg/u02 37158356 8437746 27977443 24% /u02
    /dev/vx/dsk/s-dg/u03 25804343 14183873 11104384 57% /u03
    /dev/vx/dsk/s-dg/u04 25804343 10773360 14514897 43% /u04
    /dev/vx/dsk/s-dg/u05 10321884 2796532 7318915 28% /u05
    /dev/vx/dsk/s-dg/u06 10321884 2946591 7272075 29% /u06

    ---------------------<empty record/cell separation>---------------------

    etc
    .
    .
    .
    .
    .


    I would like to transpose the "used" column as row for each sets. there are around 5 yr's information like above.

    How to do this in a loop to extract and convert it as rows.

    Appreciate your help

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,191
    Thanks
    14
    Thanked 324 Times in 318 Posts
    In Excel you can copy the data, then paste-special transpose. It can be done directly with the right-click menu

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •