m0nkeyb0y66
New Member
- Joined
- Aug 4, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am collecting sensor data from an Arduino project, and it saves the data to a text file. Each second 16 data points are collected. Three seconds of that data looks like the following with the spaces separating the data for each second it was recorded:
29.02
84.23
55.63
0.12
25.11
971
372.29
77.10
770.70
-92.70
0.06
0.02
0.05
-0.06
0.12
9.78
29.02
84.23
55.63
0.12
25.11
971
372.29
77.10
765.90
-93.30
0.07
0.02
0.05
-0.07
0.11
9.79
29.02
84.23
55.63
0.12
25.11
971
372.29
81.90
768.30
-92.70
0.06
0.00
0.05
-0.08
0.12
9.81
I have copied all of this data into an Excel spreadsheet and added a column with headings for each data point. I now have two columns that look like the following:
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 77.1
Mag Y uT:: 770.7
Mag Z uT: -92.7
Gyryo X g: 0.06
Gyryo Y g: 0.02
Gyryo Z g: 0.05
Accel X m/s^2 -0.06
Accel Y m/s^2 0.12
Accel Z m/s^2 9.78
--------------------------------------
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 77.1
Mag Y uT:: 765.9
Mag Z uT: -93.3
Gyryo X g: 0.07
Gyryo Y g: 0.02
Gyryo Z g: 0.05
Accel X m/s^2 -0.07
Accel Y m/s^2 0.11
Accel Z m/s^2 9.79
--------------------------------------
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 81.9
Mag Y uT:: 768.3
Mag Z uT: -92.7
Gyryo X g: 0.06
Gyryo Y g: 0
Gyryo Z g: 0.05
Accel X m/s^2 -0.08
Accel Y m/s^2 0.12
Accel Z m/s^2 9.81
--------------------------------------
I'd like to be able to separate the data points based on the heading that goes with them. I want to get all of the readings for Mag Z uT and be able to paste them to a separate sheet or column so that I can select them all and create a graph of the change over time. Is there a way to do this quickly? Can I select numbers in column B based on what it says in the adjacent cell in column A? For example, only select cells in column B if the adjacent cell in column A says Mag Z uT.
29.02
84.23
55.63
0.12
25.11
971
372.29
77.10
770.70
-92.70
0.06
0.02
0.05
-0.06
0.12
9.78
29.02
84.23
55.63
0.12
25.11
971
372.29
77.10
765.90
-93.30
0.07
0.02
0.05
-0.07
0.11
9.79
29.02
84.23
55.63
0.12
25.11
971
372.29
81.90
768.30
-92.70
0.06
0.00
0.05
-0.08
0.12
9.81
I have copied all of this data into an Excel spreadsheet and added a column with headings for each data point. I now have two columns that look like the following:
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 77.1
Mag Y uT:: 770.7
Mag Z uT: -92.7
Gyryo X g: 0.06
Gyryo Y g: 0.02
Gyryo Z g: 0.05
Accel X m/s^2 -0.06
Accel Y m/s^2 0.12
Accel Z m/s^2 9.78
--------------------------------------
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 77.1
Mag Y uT:: 765.9
Mag Z uT: -93.3
Gyryo X g: 0.07
Gyryo Y g: 0.02
Gyryo Z g: 0.05
Accel X m/s^2 -0.07
Accel Y m/s^2 0.11
Accel Z m/s^2 9.79
--------------------------------------
Temp ℃: 29.02
Temp ℉: 84.23
Humidity %: 55.63
Ultraviolet intensity mw/cm2: 0.12
LuminousIntensity lx: 25.11
Atmospheric pressure hpa: 971
Altitude m: 372.29
Mag X uT: 81.9
Mag Y uT:: 768.3
Mag Z uT: -92.7
Gyryo X g: 0.06
Gyryo Y g: 0
Gyryo Z g: 0.05
Accel X m/s^2 -0.08
Accel Y m/s^2 0.12
Accel Z m/s^2 9.81
--------------------------------------
I'd like to be able to separate the data points based on the heading that goes with them. I want to get all of the readings for Mag Z uT and be able to paste them to a separate sheet or column so that I can select them all and create a graph of the change over time. Is there a way to do this quickly? Can I select numbers in column B based on what it says in the adjacent cell in column A? For example, only select cells in column B if the adjacent cell in column A says Mag Z uT.
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Temp ℃: | 29.02 | ||
2 | Temp ℉: | 84.23 | ||
3 | Humidity %: | 55.63 | ||
4 | Ultraviolet intensity mw/cm2: | 0.12 | ||
5 | LuminousIntensity lx: | 25.11 | ||
6 | Atmospheric pressure hpa: | 971 | ||
7 | Altitude m: | 372.29 | ||
8 | Mag X uT: | 77.1 | ||
9 | Mag Y uT:: | 770.7 | ||
10 | Mag Z uT: | -92.7 | ||
11 | Gyryo X g: | 0.06 | ||
12 | Gyryo Y g: | 0.02 | ||
13 | Gyryo Z g: | 0.05 | ||
14 | Accel X m/s^2 | -0.06 | ||
15 | Accel Y m/s^2 | 0.12 | ||
16 | Accel Z m/s^2 | 9.78 | ||
17 | -------------------------------------- | |||
18 | Temp ℃: | 29.02 | ||
19 | Temp ℉: | 84.23 | ||
20 | Humidity %: | 55.63 | ||
21 | Ultraviolet intensity mw/cm2: | 0.12 | ||
22 | LuminousIntensity lx: | 25.11 | ||
23 | Atmospheric pressure hpa: | 971 | ||
24 | Altitude m: | 372.29 | ||
25 | Mag X uT: | 77.1 | ||
26 | Mag Y uT:: | 765.9 | ||
27 | Mag Z uT: | -93.3 | ||
28 | Gyryo X g: | 0.07 | ||
29 | Gyryo Y g: | 0.02 | ||
30 | Gyryo Z g: | 0.05 | ||
31 | Accel X m/s^2 | -0.07 | ||
32 | Accel Y m/s^2 | 0.11 | ||
33 | Accel Z m/s^2 | 9.79 | ||
34 | -------------------------------------- | |||
35 | Temp ℃: | 29.02 | ||
36 | Temp ℉: | 84.23 | ||
37 | Humidity %: | 55.63 | ||
38 | Ultraviolet intensity mw/cm2: | 0.12 | ||
39 | LuminousIntensity lx: | 25.11 | ||
40 | Atmospheric pressure hpa: | 971 | ||
41 | Altitude m: | 372.29 | ||
42 | Mag X uT: | 81.9 | ||
43 | Mag Y uT:: | 768.3 | ||
44 | Mag Z uT: | -92.7 | ||
45 | Gyryo X g: | 0.06 | ||
46 | Gyryo Y g: | 0 | ||
47 | Gyryo Z g: | 0.05 | ||
48 | Accel X m/s^2 | -0.08 | ||
49 | Accel Y m/s^2 | 0.12 | ||
50 | Accel Z m/s^2 | 9.81 | ||
51 | -------------------------------------- | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A18:A51 | A18 | =A1 |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
Print_Titles | =Sheet1!$A:$A | A18 |