A great tutorial although it does not answer what I was looking for. I have an Excel table of BP readings (4 times a day) like this: Date1 Time1 Diastolic1 Systolic1 Pulse1 Date1 Time2 Diastolic2 Systolic2 Pulse2 Date1 Time3 Diastolic3 Systolic3 Pulse3 Date1 Time4 Diastolic4 Systolic4 Pulse4 Date2 Time1 Diastolic1 Systolic1 Pulse1 Date2 Time2 Diastolic2 Systolic2 Pulse2 Date2 Time3 Diastolic3 Systolic3 Pulse3 Date2 Time4 Diastolic4 Systolic4 Pulse4 ... I would like to convert this table into a new table like this: Date1 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4 Date2 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4 .... Essentially, I want to calculate min, max, and average of columns for different periods of the day to understand the impact of BP medicine and help my doctor better titrate the medicine. Thanks for any hints you can share.
I have a question not related to this video, but you said to ask! How can I make a list of dates with matching days in another column....but only Monday-Friday ? Is that too easy? I do this every month and think there's got to be an easier way than dragging and then deleting the weekends......🤔
Amazing! never knew life would be much easier. thanks a ton!!!
A great tutorial although it does not answer what I was looking for. I have an Excel table of BP readings (4 times a day) like this:
Date1 Time1 Diastolic1 Systolic1 Pulse1
Date1 Time2 Diastolic2 Systolic2 Pulse2
Date1 Time3 Diastolic3 Systolic3 Pulse3
Date1 Time4 Diastolic4 Systolic4 Pulse4
Date2 Time1 Diastolic1 Systolic1 Pulse1
Date2 Time2 Diastolic2 Systolic2 Pulse2
Date2 Time3 Diastolic3 Systolic3 Pulse3
Date2 Time4 Diastolic4 Systolic4 Pulse4
...
I would like to convert this table into a new table like this:
Date1 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4
Date2 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4
....
Essentially, I want to calculate min, max, and average of columns for different periods of the day to understand the impact of BP medicine and help my doctor better titrate the medicine. Thanks for any hints you can share.
I have a question not related to this video, but you said to ask! How can I make a list of dates with matching days in another column....but only Monday-Friday ? Is that too easy? I do this every month and think there's got to be an easier way than dragging and then deleting the weekends......🤔
I have an Instagram short about this! instagram.com/reel/CxaiNXxr1F3/?
great but need power query more videos
Thank you for the suggestion 🙂
good！
Thank you for watching!