need help in pivot table

[#1]

Hello,i need some help, i have table from production like this:

Order No, Step No, Machine Name, Qty Out

001, 00, A, 100

001, 01, B, 80

001, 02, C, 60

002, 00, A, 200

002, 01, B, 150

002, 10, C, 120

I need:

001, 01, B, 80, 100 (from prev step)

001, 02, C, 60, 80 (from prev step)

002, 01, B, 150, 200 (from prev step)

002, 10, C, 120,150 (from prev step)

Any sugestion how to make it in QV? I can make it in SQL - but prefer QV.

Thanks in advance

[#2 · Accepted solution]

Mimarcin, Have look at the attched application.

Hope this helps you.

- Sridhar

[#3]

You are great