Answer to q1: yes. Step 1 is to make a backup copy of your data so you
don't accidentally lose anything, and learn the procedure that follows
on your backup copy.

All you need to do is highlight your data, then click Edit Copy.
Move to a new space in the worksheet, or a new tab; click Edit Paste
Special and select the Transpose box. Rows become columns and vice
versa.

I don't know about q2- if Excel is working for you, and particularly if
you're tracking differences in sleep / weight / BP over time, you may
want to stay with Excel since it does math, graphs, etc.