Home » Forums » Open Source Learning Center » Question and Answer

please help me with this problem

Submitted by lacatica on 12 May, 2011 - 11:39

Hello,
having verticaly from A1 to let`s say A10 the next values
1
2
3
4
5
6
7
8
9
10

I want to bring them horizontaly but mirrored (starting with the last value):

10 9 8 7 6 5 4 3 2 1

Can somebody help me? Thanks a lot.

‹ Excel VBA Help How to use Case Statements (about 30) on Multiple Rows of Data? ›
»

Thanks a lot backwards!

Submitted by lacatica on 12 May, 2011 - 12:47.

Thanks a lot backwards!

»

Here's how

Submitted by backwards on 12 May, 2011 - 12:28.

1) Add a column beside your data (say, column A)
2) On the first row, type 1
3) Right-click and drag the cell handle down to the last row of data and select Fill Series
4) Select the data
5) Sort it by Column A descending
6) Select your data only (say column B)
7) Copy (CTRL+C)
8) Select an empty cell
9) Select Paste Special (ALT+E, S)
10) Check "Transpose"
11) OK to paste

»