1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

create an excel macro to reorganise data?

Discussion in 'Business Applications' started by frankcase, Feb 6, 2005.

Thread Status:
Not open for further replies.
  1. frankcase

    frankcase Thread Starter

    Joined:
    Feb 6, 2005
    Messages:
    9
    Hi,
    I have a major problem crunching large amounts of numbers coming off an instrument I work with but the file format it puts the results into is terrible and I cannot change it. So I must export the results in a format which needs some serious formating before it becomes of any use to me.

    I have used excel macros to delete rows and rows with specific text values. But now I would like to create a macro that will reorganise this data in a more user friendly format. I did use the sort asending command to partially solve the formating problem but it would still require alot of work/time to organise it into the final format I need.

    This is the current format of the instrument date:

    Analyte Meas. Intensity
    Rh 10
    Y 98
    Cs 66
    Co 98
    Analyte Meas. Intensity
    Rh 10
    Y 114
    Cs 72
    Co 86
    Analyte Meas. Intensity
    Rh 20
    Y 108
    Cs 44
    Co 90
    Analyte Meas. Intensity
    Rh 20
    Y 68
    Cs 44
    Co 66
    Analyte Meas. Intensity
    Rh 490.008
    Y 58
    Cs 34
    Co 78


    Used the "sort asending" command to separate data into useful form but need to get the data into either of the two tables shown below

    Analyte Meas. Intensity
    Analyte Meas. Intensity
    Analyte Meas. Intensity
    Analyte Meas. Intensity
    Analyte Meas. Intensity
    Co 98
    Co 86
    Co 90
    Co 66
    Co 78
    Cs 66
    Cs 72
    Cs 44
    Cs 44
    Cs 34
    Rh 10
    Rh 10
    Rh 20
    Rh 20
    Rh 490.008
    Y 98
    Y 114
    Y 108
    Y 68
    Y 58


    I would like to turn the data into this final format using a macro.

    Co Cs Rh Y
    98 66 10 98
    86 72 10 114
    90 44 20 108
    66 44 20 68
    78 34 490.008 58

    Can somebody help me please as I have thousands of numbers to crunch ASAP.
    Bye,
    Frank
     
  2. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    ZIP and post a sample workbook.


    Rollin
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/327551

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice