Sorry for so many questions today, I will show you the data then explain:
| Name | Value |
| Avg_Age IOL Impl (yr) | 9.762942466 |
| StdDev_Age IOL Impl (yr) | 5.149931391 |
| Max_Age IOL Impl (yr) | 24.16986301 |
| Min_Age IOL Impl (yr) | 1.339726027 |
| Avg_IOL Power (D) | 14.61304348 |
| StdDev_IOL Power (D) | 3.476147337 |
| Max_IOL Power (D) | 20 |
| Min_IOL Power (D) | 6 |
| Avg_Preop IOL Ref Sph | -14.07391304 |
| StdDev_Preop IOL Ref Sph | 3.919694693 |
| Max_Preop IOL Ref Sph | -4.75 |
| Min_Preop IOL Ref Sph | -24 |
This is the output data of my summarized data then transposed: my desire is to re-create this graph in a more condensed scientific manner for presentation:
I would look to create 2 new cells from the 4 cells worth of data:
1) I am looking to take the Avg_Age IOL Impl and StdDev_Age IOL Impl (basically the averages and standard deviations from these results) and putting them into one cell aka ([Avg_Age IOL Impl] +/- [StdDev_Age IOL Impl]).
2) Take the max & min, and create a new cell using ([Max_Age IOL Impl] to [Min_Age IOL Impl]). So taking these 4 cells down to 2 simplified cells in a simple format.
I would be looking for the following kind of output to give you a better reference for what I am looking for (not necessarily inputting it in that format - could just use the cells that are combined and removed those empty in the example column)
| Name | Value | EXAMPLE COLUMN |
| Avg_Age IOL Impl (yr) | 9.76 | 9.76 +/- 5.15 |
| StdDev_Age IOL Impl (yr) | 5.15 | |
| Max_Age IOL Impl (yr) | 24.17 | 1.34 to 24.17 |
| Min_Age IOL Impl (yr) | 1.34 | |
| Avg_IOL Power (D) | 14.61 | 14.61 +/- 3.48 |
| StdDev_IOL Power (D) | 3.48 | |
| Max_IOL Power (D) | 20.00 | 6 to 20 |
| Min_IOL Power (D) | 6.00 | |
| Avg_Preop IOL Ref Sph | -14.07 | -14.07 +/- 3.92 |
| StdDev_Preop IOL Ref Sph | 3.92 | |
| Max_Preop IOL Ref Sph | -4.75 | -24 to -4.75 |
| Min_Preop IOL Ref Sph | -24.00 | |
Thank you in advance for your help and if you need any more clarification please feel free to ask. I greatly appreciate it,
Nick
