Paste Special Tranpose for formulas

[eugchen]

this is sort of hard to explain for me....i have data in formulas that is in Column A, lets say cells A1-A6. i want to put those cells (not the value, but the cell formulas) in Row C1-H1.

the data in A1-A6 will change daily and i want C1-H1 to reflect that. i have a ton more rows and columns but simplifying here the purposes here. the real data goes from A1-A245.

is there an easy way to copy the cells from A1-A6 and do some sort of paste into C1-H1 where the formulas are copied?

the formulas i want to show up in C1-H1 are the following

C1=A1
D1=A2
E1=A3
F1=A4
G1=A5
H1=A6

not sure the easiest way to accomplish this. hope this makes sense.

[Keebellah]

Hi, I think this is only possible using a macro, in that case, the answer is 'yes you can'
But you say you have up to 245 rows in A,, only one in C1 to H1? can you explain a little more?

[eugchen]

yea sorry...specifically, i have data in Rows A1-A245 (that changes daily), i want that same data in row C1-IM1, but i want the values in C1-IM1 to get updated when A1-A245 get updated.

i can just manually input the following
C1=A1
D1=A2

etc.

but was looking for a quicker way

[XOR LX]

Hi,

In C1:

=INDEX($A:$A,COLUMNS($A1:A1))

and copied right as required.

Regards

[Ghozi Alkatiri]

=index($a:$a,column(a:a))

[eugchen]

exactly what i was looking for. thanks!!!!