Blood pressure data summary Pivot Table - unable to create the desired result

[GCYR01]

I have blood pressure measures coming from a Withings BP monitor organized by day and would like to create an 'easy to read" report that my doctor can use to recommend the right medication.

I tried hard and looked at many useless youtube examples for my need but I am still not able to get it organized correctly in 4 columns and 3 rows using a standard pivot table, Can you please help?

Here is a sample of the raw data: BP Data.png

The desired summary: Desired Result.png (need a max, min, average and std dev of the 3 values for the entire dataset (filtered by a date range or by the medication name on demand)

Secondly, I need this data to be organised or filtered by date range.

 

[awoohaw]

You can unpivot your data using power query (or manually or with formulas). and then do this:

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	Date/Time	Measure	Measurement
2	2024-03-01 07:00	HeartRate	78
3	2024-03-01 07:00	Systolic	144			Row Labels	Average	Max	Min	StdDev
4	2024-03-01 07:00	Diastolic	84			Diastolic	95	110	75	10
5	2024-03-01 19:00	HeartRate	83			HeartRate	87	98	75	7
6	2024-03-01 19:00	Systolic	135			Systolic	159	199	118	25
7	2024-03-01 19:00	Diastolic	100			Grand Total	114	199	75	36
8	2024-03-02 10:00	HeartRate	76
9	2024-03-02 10:00	Systolic	158
10	2024-03-02 10:00	Diastolic	107
11	2024-03-02 18:00	HeartRate	94
12	2024-03-02 18:00	Systolic	118
13	2024-03-02 18:00	Diastolic	107
14	2024-03-03 03:00	HeartRate	98
15	2024-03-03 03:00	Systolic	187
16	2024-03-03 03:00	Diastolic	105
17	2024-03-03 13:00	HeartRate	83
18	2024-03-03 13:00	Systolic	123
19	2024-03-03 13:00	Diastolic	101
20	2024-03-04 04:00	HeartRate	94
21	2024-03-04 04:00	Systolic	126
22	2024-03-04 04:00	Diastolic	91
23	2024-03-04 22:00	HeartRate	93
24	2024-03-04 22:00	Systolic	159
25	2024-03-04 22:00	Diastolic	88
26	2024-03-05 06:00	HeartRate	91
27	2024-03-05 06:00	Systolic	150
28	2024-03-05 06:00	Diastolic	97
29	2024-03-05 22:00	HeartRate	75
30	2024-03-05 22:00	Systolic	178
31	2024-03-05 22:00	Diastolic	109
32	2024-03-06 06:00	HeartRate	94
33	2024-03-06 06:00	Systolic	151
34	2024-03-06 06:00	Diastolic	90
35	2024-03-06 17:00	HeartRate	89
36	2024-03-06 17:00	Systolic	153
37	2024-03-06 17:00	Diastolic	83
38	2024-03-07 06:00	HeartRate	78
39	2024-03-07 06:00	Systolic	144
40	2024-03-07 06:00	Diastolic	75
41	2024-03-07 21:00	HeartRate	92
42	2024-03-07 21:00	Systolic	194
43	2024-03-07 21:00	Diastolic	78
44	2024-03-08 02:00	HeartRate	89
45	2024-03-08 02:00	Systolic	170
46	2024-03-08 02:00	Diastolic	96
47	2024-03-08 20:00	HeartRate	81
48	2024-03-08 20:00	Systolic	157
49	2024-03-08 20:00	Diastolic	86
50	2024-03-09 11:00	HeartRate	80
51	2024-03-09 11:00	Systolic	140
52	2024-03-09 11:00	Diastolic	110
53	2024-03-09 21:00	HeartRate	89
54	2024-03-09 21:00	Systolic	199
55	2024-03-09 21:00	Diastolic	84
56	2024-03-10 00:00	HeartRate	86
57	2024-03-10 00:00	Systolic	194
58	2024-03-10 00:00	Diastolic	104
59	2024-03-10 16:00	HeartRate	76
60	2024-03-10 16:00	Systolic	167
61	2024-03-10 16:00	Diastolic	90
62	2024-03-11 03:00	HeartRate	94
63	2024-03-11 03:00	Systolic	133
64	2024-03-11 03:00	Diastolic	101
65	2024-03-11 14:00	HeartRate	92
66	2024-03-11 14:00	Systolic	193
67	2024-03-11 14:00	Diastolic	92
68	2024-03-12 01:00	HeartRate	96
69	2024-03-12 01:00	Systolic	191
70	2024-03-12 01:00	Diastolic	103
71
HRandBP

 

[GCYR01]

You can unpivot your data using power query (or manually or with formulas). and then do this:


View attachment 109423

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	Date/Time	Measure	Measurement
2	2024-03-01 07:00	HeartRate	78
3	2024-03-01 07:00	Systolic	144			Row Labels	Average	Max	Min	StdDev
4	2024-03-01 07:00	Diastolic	84			Diastolic	95	110	75	10
5	2024-03-01 19:00	HeartRate	83			HeartRate	87	98	75	7
6	2024-03-01 19:00	Systolic	135			Systolic	159	199	118	25
7	2024-03-01 19:00	Diastolic	100			Grand Total	114	199	75	36
8	2024-03-02 10:00	HeartRate	76
9	2024-03-02 10:00	Systolic	158
10	2024-03-02 10:00	Diastolic	107
11	2024-03-02 18:00	HeartRate	94
12	2024-03-02 18:00	Systolic	118
13	2024-03-02 18:00	Diastolic	107
14	2024-03-03 03:00	HeartRate	98
15	2024-03-03 03:00	Systolic	187
16	2024-03-03 03:00	Diastolic	105
17	2024-03-03 13:00	HeartRate	83
18	2024-03-03 13:00	Systolic	123
19	2024-03-03 13:00	Diastolic	101
20	2024-03-04 04:00	HeartRate	94
21	2024-03-04 04:00	Systolic	126
22	2024-03-04 04:00	Diastolic	91
23	2024-03-04 22:00	HeartRate	93
24	2024-03-04 22:00	Systolic	159
25	2024-03-04 22:00	Diastolic	88
26	2024-03-05 06:00	HeartRate	91
27	2024-03-05 06:00	Systolic	150
28	2024-03-05 06:00	Diastolic	97
29	2024-03-05 22:00	HeartRate	75
30	2024-03-05 22:00	Systolic	178
31	2024-03-05 22:00	Diastolic	109
32	2024-03-06 06:00	HeartRate	94
33	2024-03-06 06:00	Systolic	151
34	2024-03-06 06:00	Diastolic	90
35	2024-03-06 17:00	HeartRate	89
36	2024-03-06 17:00	Systolic	153
37	2024-03-06 17:00	Diastolic	83
38	2024-03-07 06:00	HeartRate	78
39	2024-03-07 06:00	Systolic	144
40	2024-03-07 06:00	Diastolic	75
41	2024-03-07 21:00	HeartRate	92
42	2024-03-07 21:00	Systolic	194
43	2024-03-07 21:00	Diastolic	78
44	2024-03-08 02:00	HeartRate	89
45	2024-03-08 02:00	Systolic	170
46	2024-03-08 02:00	Diastolic	96
47	2024-03-08 20:00	HeartRate	81
48	2024-03-08 20:00	Systolic	157
49	2024-03-08 20:00	Diastolic	86
50	2024-03-09 11:00	HeartRate	80
51	2024-03-09 11:00	Systolic	140
52	2024-03-09 11:00	Diastolic	110
53	2024-03-09 21:00	HeartRate	89
54	2024-03-09 21:00	Systolic	199
55	2024-03-09 21:00	Diastolic	84
56	2024-03-10 00:00	HeartRate	86
57	2024-03-10 00:00	Systolic	194
58	2024-03-10 00:00	Diastolic	104
59	2024-03-10 16:00	HeartRate	76
60	2024-03-10 16:00	Systolic	167
61	2024-03-10 16:00	Diastolic	90
62	2024-03-11 03:00	HeartRate	94
63	2024-03-11 03:00	Systolic	133
64	2024-03-11 03:00	Diastolic	101
65	2024-03-11 14:00	HeartRate	92
66	2024-03-11 14:00	Systolic	193
67	2024-03-11 14:00	Diastolic	92
68	2024-03-12 01:00	HeartRate	96
69	2024-03-12 01:00	Systolic	191
70	2024-03-12 01:00	Diastolic	103
71
HRandBP

Thank you so much, it worked perfectly!

 

[awoohaw]

My pleasure. I'm happy to help. Best Wishes!