Split multiple data scans into separate colum

Closed
DUchemist - Aug 15, 2011 at 12:45 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Aug 16, 2011 at 10:46 AM
Hello,

I'd like to split my data from two columns into multiple columns in order to do averaging.
My data looks like this:
Mass| Intensity
XX | YY
XX | YY
...
Mass|Intensity
XX2 | YY2
XX2 | YY2

This repeats for an X number of scans depending on the run. The mass values are the same through out so if it is possible to somehow move the intensities into rows following the mass that would be great. There are 6000 mass points per scan.
I usually use a separate data application that I don't have access to at the moment and was hoping someone can lead me in the right direction with Excel.

Thanks in advance.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 16, 2011 at 10:46 AM
Is this part of data "Mass|Intensity" I mean does it repeat ?

In essense, you can copy the copy and use paste special to paste as row by transpose. Can be done manually or via macro
0