create an excel macro to reorganise data?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top