excel 2007 Move Data From Columns To Rows

September 15, 2011 at 23:29:15
Specs: Windows XP
I have this.....

Fred Wuffin
7601 Chruchill Way
Baton Rouge, LA 70803
age-32


I want this.....
Fred Wuffin 7601 Chruchill Way Baton Rouge, LA 70803

And each block is separated by more than 1 block.


See More: excel 2007 Move Data From Columns To Rows

Report •

#1
September 16, 2011 at 08:50:22
Sounds like you want to transpose your data.

How To Ask Questions The Smart Way


Report •

#2
September 16, 2011 at 09:03:49
...and it looks like you should use a more descriptive Subject Line.

If everyone used a Subject Line like "Excel 2007" we wouldn't be able to tell one question from another.

I've edited the Subject Line of this thread, but you should try to be more descriptive going forward.

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
September 16, 2011 at 09:08:02
DerbyDad03, I don't know if I've mentioned this before but I love it how you sign your posts as the forum moderator whenever the OP annoys you.

How To Ask Questions The Smart Way


Report •

Related Solutions

#4
September 16, 2011 at 09:31:37
Actually, you need to dig a little deeper.

For the most part, I sign as the moderator when I've edited the body or title of the post as an indication to the OP that the changes were made by someone with the (dare I say it?) "authority" to make those changes.

I wouldn't want the OP to think that any member of the forum can make those types of changes.

In general, when I'm acting and responding as the moderator, I let the OP know. When I'm just another member offering a solution, I don't feel that there is a need to include the fact that I'm the moderator.

I handle that the same way I handle communications in my real life. Sometimes I'm Coach DerbyDad03, sometimes I'm (my professional title) DerbyDad03 and sometimes I'm just DerbyDad03.

I'm torn as to how to sign this particular post ;-)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question