Simple problem?

[Ond]

Hi there, a simple problem.

If I have the following:
A X
B XX
C XXX
D XXXX

Which formula do I use to change this into the following:
A XXXX
B XXX
C XX
D X


Regards,
Ond.

 

[pd_it_guy]

Unclear what you are trying to accomplish with all this. If the string in A1 is always the same,

=mid(a1,1,1) will pick off the first place character.

knowing that, you can concat as many instances of this as you like, thus:

=mid(a1,1,1)&mid(a1,1,1) and so forth

What are you trying to do?

 

[PA HS Teacher]

How about?

In C2 and Pasted Down:
=INDEX(B$2:B$5,ROWS(B$2:B$5)-ROW(B2)+ROW(B$2))

Book2
	A	B	C	D
2	A	XXXX	X
3	B	XXX	XX
4	C	XX	XXX
5	D	X	XXXX
Sheet2

 

[ravishankar]

HI
IN col B paste the formula
=INDIRECT("A" & COUNT(A:A)-ROW()+1) drag it till the end of data
Ravi

 

[Ond]

Hi there.

I'm sorry, I didn't specify my problem well enough. Let my try again. I have the following:

The only thing I want to do is to reverse the order of things that are written in the columns.

As you can see the order in column C is the reverse order of things written in column A (but I wrote it "by hand"). Is there a formula for doing such a thing?

Kind regards again,
Ond.

 

[PA HS Teacher]

If that is all you want to do.

I'd put numbers,
1,2,3 etch (and past down) in an adjacent column.

Hightlight the 2 columns, and sort ascending or descending as desired.

 

[ravishankar]

Hi
My formula above does precisely what you are asking for.
Ravi