Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 21st 05, 12:48 AM
 
Posts: n/a
Default How to swap rows and columns?

I had a heart attack last year, and my doctor told me to keep a
journal of diet, exercise, etc. I'm using an Excel worksheet to do
it. Each column is a day of the year, and the rows are items, like
how far I walked that day, how much I ate, how much sleep, my weight,
my blood pressure, etc. As I got in the habit of using it, I started
adding other stuff, so now it's become an important repository of data
for me.

The problem is, I thought Excel had essentially unlimited rows and
columns, and it turns out that it only has 256 columns, which isn't
enough for a year. It has thousands of rows, and I have way less than
200 categories of activities I record, so if I could just switch the
rows and columns around, I would be OK.

So I have two questions:

1) Is there any way to swap the rows and columns around, without
losing the data? In other words, can I change it so that the rows are
the dates, and the columns are the activities?

2) Is there a relatively cheap and easy to learn program that would be
better than Excel for what I'm doing (daily journal)?

Thanks for any help.





  #2   Report Post  
Old September 21st 05, 12:58 AM
Anne Troy
 
Posts: n/a
Default

Actually, I cannot think of a better/easier program to use for your purpose.
Way to go.
Now select ALL your data, and hit Ctrl+C to copy it.
Go to a new worksheet and hit Edit--Paste special--Transpose.
That's it!
Stay healthy!
************
Anne Troy
www.OfficeArticles.com

wrote in message
news
I had a heart attack last year, and my doctor told me to keep a
journal of diet, exercise, etc. I'm using an Excel worksheet to do
it. Each column is a day of the year, and the rows are items, like
how far I walked that day, how much I ate, how much sleep, my weight,
my blood pressure, etc. As I got in the habit of using it, I started
adding other stuff, so now it's become an important repository of data
for me.

The problem is, I thought Excel had essentially unlimited rows and
columns, and it turns out that it only has 256 columns, which isn't
enough for a year. It has thousands of rows, and I have way less than
200 categories of activities I record, so if I could just switch the
rows and columns around, I would be OK.

So I have two questions:

1) Is there any way to swap the rows and columns around, without
losing the data? In other words, can I change it so that the rows are
the dates, and the columns are the activities?

2) Is there a relatively cheap and easy to learn program that would be
better than Excel for what I'm doing (daily journal)?

Thanks for any help.






  #3   Report Post  
Old September 21st 05, 01:00 AM
Dave O
 
Posts: n/a
Default

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.

  #5   Report Post  
Old September 21st 05, 01:24 AM
Dave Peterson
 
Posts: n/a
Default

And just some thoughts...

Be as granular as you can.

Use separate columns for the systolic and one column for the diastolic
measurements. (It'll be easier to do math that way.)

If you take your measurements a couple of times per day, use a different pair
for each instance.

If you keep track of the time you eat, use multiple columns--time and items (you
can use alt-enter to force new lines within a cell for the thanksgiving feast!)

You may want to apply data|Filter|autofilter to see different rows (filter by
day to see how you're doing on weekends??)

And you may want to use format|conditional formatting to highlight those out of
ordinary numbers.

Save often and make backups!

(I find a food diary (pen and notebook) easier to use for the diet stuff.)



wrote:

I had a heart attack last year, and my doctor told me to keep a
journal of diet, exercise, etc. I'm using an Excel worksheet to do
it. Each column is a day of the year, and the rows are items, like
how far I walked that day, how much I ate, how much sleep, my weight,
my blood pressure, etc. As I got in the habit of using it, I started
adding other stuff, so now it's become an important repository of data
for me.

The problem is, I thought Excel had essentially unlimited rows and
columns, and it turns out that it only has 256 columns, which isn't
enough for a year. It has thousands of rows, and I have way less than
200 categories of activities I record, so if I could just switch the
rows and columns around, I would be OK.

So I have two questions:

1) Is there any way to swap the rows and columns around, without
losing the data? In other words, can I change it so that the rows are
the dates, and the columns are the activities?

2) Is there a relatively cheap and easy to learn program that would be
better than Excel for what I'm doing (daily journal)?

Thanks for any help.


--

Dave Peterson


  #6   Report Post  
Old September 21st 05, 08:07 AM
[email protected]
 
Posts: n/a
Default

The copy with transpose worked perfectly. Thank you all for the help,
and for the good wishes.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting columns within certain rows only crimsonkng Excel Discussion (Misc queries) 4 July 14th 05 05:13 PM
Repeating Rows and Columns on each page of print out BruceM Excel Discussion (Misc queries) 1 July 6th 05 12:28 PM
hidden rows & columns slow file open Simon Shaw Excel Discussion (Misc queries) 0 April 5th 05 12:21 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017