How to transpose column A based on values in Column B in excel ?

[Maged Kamal]

i need equation to transpose list in column A to be from D1 to N1 based on its values in Column B

Name

Amount

F

C

E

D

K

B

G

I

A

H

J

A

150

B

200

C

600

D

300

E

400

F

800

G

200

H

100

I

200

J

100

K

300

<colgroup><col width="72" span="2" style="width:54pt"> <col width="72" span="12" style="width:54pt"> </colgroup><tbody>
</tbody>

 

[strooman]

Highlight D1:O2
formula in D1: =TRANSPOSE(A1:B12)
Hit Ctrl+Shift+Enter

Row\Col

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

1​

Name

Amount

Name

A

B

C

D

E

F

G

H

I

J

K

2​

A

150​

Amount

150​

200​

600​

300​

400​

800​

200​

100​

200​

100​

300​

3​

B

200​

4​

C

600​

5​

D

300​

6​

E

400​

7​

F

800​

8​

G

200​

9​

H

100​

10​

I

200​

11​

J

100​

12​

K

300​

 

[Maged Kamal]

i am so sorry i forgot to tell you that i need to be in decending order based on values in column b

 

[strooman]

I'm sorry I didn't read your question accurately. My mistake. I will look tonight cause I'm at work right now.

 

[strooman]

Sorry for the delay. Work was calling and I forgot about your question.

In D2: =LARGE($B$2:$B$12;COLUMN(A1))
Copy from left to right

In D1: =INDEX($A$2:$A$12;SMALL(IF($B$2:$B$12=D2;ROW($A$2:$A$12)-ROW($A$2)+1);COUNTIF($D$2:D2;D2)))
Entered with Ctrl+Shift+Enter. NOT just Enter.
Copy from left to right

Row\Col

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

1​

Name

Amount

F​

C​

E​

D​

K​

B​

G​

I​

A​

H​

J​

2​

A

150​

800​

600​

400​

300​

300​

200​

200​

200​

150​

100​

100​

3​

B

200​

​

​

4​

C

600​

5​

D

300​

​

​

6​

E

400​

​

​

7​

F

800​

​

​

8​

G

200​

​

​

9​

H

100​

​

​

10​

I

200​

​

​

11​

J

100​

​

​

12​

K

300​

​

​