convert horizontal to vertical

[syuk225]

Account ID Product Total
Hello guys..I need a formula to do like as shown below


2395380 Chicken $2.34 Account ID Chicken Tomato Beef Jar Rice Pasta
Tomato $0.80 2395380 $2.34 $0.80 $0.20 $13.00
Beef $0.20 2460127 $1.00 $13.00
Jar $13.00 2461125 $13.00
2460127 Chicken $1.00 2461126 $4.30 $0.10 $5.40 $14.80 20.58
Jar $13.00
2461125 Beef $13.00
2461126 Tomato $4.30
Pasta $20.58
Beef $0.10
Jar $5.40
Rice $14.80

I hope anyone can help me this as the records i'm doing is about thousand of plus, doing it manually is tideous..so i very much highly appreciated if anyone can solved it//

[Søren Larsen]

It's difficult to see from your post how the data is arranged. But you might want to experiment using =TRANSPOSE().