I have a column of formulas that generate data. I want to create from that column the same data but in a row. The copy/paste/transpose does not work for these formulas. It works for raw data but not for formulas. As the data changes in the column, I want it reflected in the rows. I have tried this several ways with the copy paste command, utilizing the formulas selection, but nothing seems to work.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Transposing
- Thread starter MKIRK
- Start date
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
Hi, MKIRK,
Welcome to the Board !!!!!
when there are only absolute references (or named ranges) within your formulas, then you would succeed with your method
would this do what you need ?
select range B1:E1
{=TRANSPOSE(A2:A5)}
(confirm with SHIFT-CONTROL-ENTER instead of just ENTER)
kind regards,
Erik
Welcome to the Board !!!!!
when there are only absolute references (or named ranges) within your formulas, then you would succeed with your method
would this do what you need ?
select range B1:E1
{=TRANSPOSE(A2:A5)}
(confirm with SHIFT-CONTROL-ENTER instead of just ENTER)
kind regards,
Erik
Upvote
0
erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
the cells are somehow "linked" as a group when confirming formulas this way
we call this an arrayformula
when you want to change the formula you need to do all cells from the array at once !
try to change one singel cell: you will get an errormessage
best regards,
Erik
Upvote
0
Similar threads
