Hello,
I currently paste some data into excel from a different source and then work to format it the way I would like. Right now, the data is pasted in horizontally. I create a few summary columns off to the side in which I select the cells I would like horizontally and select paste special -> values, transpose. Is there a formula approach to this?
So I would like a formula to display cells vertically from the current data that is displayed horizontally.
IE: Data is formatted to be in cells B2, C2, D2....and I would like a formula that I can propogate downward in Column X. So in X2 I will have the formula "=B$2" and then be able to drag it downward to display cell C2 in cell X3.
I can't figure out how to tell excel to move over one cell instead of always down one cell. Hopefully it is clear what I am looking to do.
Any help would be appreciated, thanks.
I currently paste some data into excel from a different source and then work to format it the way I would like. Right now, the data is pasted in horizontally. I create a few summary columns off to the side in which I select the cells I would like horizontally and select paste special -> values, transpose. Is there a formula approach to this?
So I would like a formula to display cells vertically from the current data that is displayed horizontally.
IE: Data is formatted to be in cells B2, C2, D2....and I would like a formula that I can propogate downward in Column X. So in X2 I will have the formula "=B$2" and then be able to drag it downward to display cell C2 in cell X3.
I can't figure out how to tell excel to move over one cell instead of always down one cell. Hopefully it is clear what I am looking to do.
Any help would be appreciated, thanks.