Results 1 to 6 of 6

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Mar:2009
    Location: Plovdiv
    Posts: 37

    Excel



    Code:
    R426   B1    1.9547  
    1      F1    1.6942  
    1      F2    1.7023  
    R426   B2    1.9624  
    1      B1    1.1889  
    2      F1    2.0537  
    2      F2    2.0451  
    1      B2    1.1802
    .
    B1 F1 B1 F1 , F2 B2 F2 B2.

    .

    Code:
    R426   B1   1.9547          1            F2   1.7023
    1      F1   1.6942          R426         B2   1.9624
    1      B1   1.1889          2            F2   2.0451
    2      F1   2.0537          1            B2   1.1802

  2. #2
    Registered User VoyagerX's Avatar
    Join Date: Dec:2005
    Location:
    Posts: 17,813
    - , , ( Excel 2010):
    (B1;F1;F2...) . . Text to Columns - . , , .
    :
    Code:
    R426	B1	1.9547
    1	B1	1.1889
    1	F1	1.6942
    2	F1	2.0537
    R426	B2	1.9624
    1	B2	1.1802
    1	F2	1.7023
    2	F2	2.0451
    - CUT PASTE.

    edit: , -, , , .
    CPU:Ryzen 7 5800X3D + Arctic Liquid Freezer II 280; MB:Asus Crosshair VII; RAM:2x8GB GSKILL F4-3200C14D-16GTZRX; VGA:Saphire RX 5700XT Nitro+; HDD:Samsung 970 EVO Plus 1TB+860 EVO 500GB+860EVO 1TB; PSU:Seasonic X-760; CASE:FD Define R6 TG; DSPL:Samsung C32HG70; SPKR:Logitech Z906;

  3. #3
    Registered User
    Join Date: Mar:2009
    Location: Plovdiv
    Posts: 37
    VoyagerX B1 B1 F1 F1 B2 B2 . .

    B1 F1 B1 F1 F2 B2 F2 B2.


  4. #4
    Registered User vekatatd's Avatar
    Join Date: Apr:2007
    Location: sofia
    Posts: 293
    pivot table .

  5. #5
    Registered User VoyagerX's Avatar
    Join Date: Dec:2005
    Location:
    Posts: 17,813
    Quote Originally Posted by vekatatd View Post
    pivot table .
    pivot - . IF B1, F1 .
    CPU:Ryzen 7 5800X3D + Arctic Liquid Freezer II 280; MB:Asus Crosshair VII; RAM:2x8GB GSKILL F4-3200C14D-16GTZRX; VGA:Saphire RX 5700XT Nitro+; HDD:Samsung 970 EVO Plus 1TB+860 EVO 500GB+860EVO 1TB; PSU:Seasonic X-760; CASE:FD Define R6 TG; DSPL:Samsung C32HG70; SPKR:Logitech Z906;

  6. #6
    Registered User
    Join Date: Mar:2009
    Location: Plovdiv
    Posts: 37
    vekatatd

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |