Thank you very much. It is very useful for me.

As you said, use of a temporary table is better and more efficient.

I have tried your two solutions and it is...

Jeff Moden (7/5/2012)

---

rhythmk (7/5/2012)

---

Javier-157657 (7/5/2012)

---

Each 3 rows in original table go to one row in the new view.

E.g:

Row1,Row2 and Row3 from original table go to Column1, Column2 and Column3...

Each 3 rows in original table go to one row in the new view.

E.g:

Row1,Row2 and Row3 from original table go to Column1, Column2 and Column3 in the first row...

It works fine.

Thank you David for your help.

There is a maximum of 5.

There are items that may have 1 or 2, and others up to 5.