Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask John D Your Own Question

John D, Engineering Consultant

Category: Networking

Satisfied Customers: 9666

Experience: Bachelor of Science - Engineering Consultant

53785

Type Your Networking Question Here...

John D is online now

I have a row of share prices that update from the internet.

This answer was rated:

★★★★★

I have a row of share prices that update from the internet. I want to transpose them into a column. I can do it in value form using the excel paste special transpose function but then they don't update in the column.

I can 'convert' the row of share prices into formulas by =cell in which the stock price is but then if I try to transpose my row of formulas, excel transposes by number i.e. A1,A2,A3 instead of A1,B1,C1....

Yes. First I tried copying the row of stock prices and then paste special transpose into another worksheet-that works fine but I just get the values so each time the stock prices refresh I have to copy/transpose...

So, I figured let's 'convert' the share prices into formula by going =the cell in which the stock price result is.

A B C

My row is IBM GE BAC

117.16 14.50 17.02

I want:

IBM

GE

BAC

So I go in another worksheet =117.16 to 'convert' the 117.16 into a 'formula' and try copy paste special transpose and I get A1, A2, A3 instead of A1,B1,C1.......

No, with paste special you are just copying static values. With the transpose function however a link will be maintained between the copied cells and the transposed cells so that any change in the original cell will be reflected in the transpose cell. I can give you the steps for creating these formulas, or set it up for you on your own file. Let me know which one you prefer.

No, with paste special you are just copying static values. With the transpose function however a link will be maintained between the copied cells and the transposed cells so that any change in the original cell will be reflected in the transpose cell. I can give you the steps for creating these formulas, or set it up for you on your own file. Let me know which one you prefer.

John D and 7 other Networking Specialists are ready to help you