Transpose columns to rows with spaces
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. |
Transpose columns to rows with spaces
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 -- Gary''s Student - gsnu200713 |
Transpose columns to rows with spaces
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. "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200713 |
Transpose columns to rows with spaces
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 -- Gary''s Student - gsnu200713 |
Transpose columns to rows with spaces
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. "dougaf" wrote: 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. |
All times are GMT +1. The time now is 08:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com