Transpose columns to rows with spaces

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dougaf - 03 Apr 2007 00:42 GMT

I have:

name
address
phone#
(empty cell)
name
address
phone#

I need:

name address phone#
name address phone#

I have a large # of items. Any help would be greatly appreciated.

Reply to this Message

Gary''s Student - 03 Apr 2007 01:18 GMT

If you data is in column A then in B1 enter:
=INDIRECT("A" & ROW()*4-5+COLUMN())

then copy this formula down columns B, C, and D

Signature

Gary''s Student - gsnu200713

Reply to this Message

dougaf - 04 Apr 2007 15:18 GMT

Thank you for the formula it really helped. I have one more quick ?...now
that I have the data in the format that I want, how can I copy it to another
worksheet for sorting, moving, ect.? Since the cells are referencing the "A"
column, I am not able to work with the data. I really appreciate your help.
It's saving me a massive amount of time.

> If you data is in column A then in B1 enter:
> =INDIRECT("A" & ROW()*4-5+COLUMN())
>
> then copy this formula down columns B, C, and D

Reply to this Message

Gary''s Student - 04 Apr 2007 23:36 GMT

Select all the cels with the transposed data in them and do a copy.

Then go to the othre worksheet or workbook and:

Paste/Special/Values

Signature

Gary''s Student - gsnu200713

Reply to this Message

PlayingToAudienceOfOne - 31 May 2007 16:46 GMT

Select the cells that you want to switch.
Click Copy
Select the upper-left cell of the paste area.
The paste area must be outside the copy area.
On the Edit menu, click Paste Special.
Select the Transpose check box.

> I have:
>
[quoted text clipped - 12 lines]
>
> I have a large # of items. Any help would be greatly appreciated.

Reply to this Message