Viewing one row twice on the same page

[silver]

What I'm trying to do is make an order form that consists of 4 columns:
v - catalog # - title - price. But I'd like to see them twice on the
same page. So that my header row will show: v - catalog # - title -
price - v - catalog # - title - price. And I need to sort this
alphabetically by the title row.

I don't know if I can just adjust the page view somehow OR if I'll have
to have 8 rows. A - H. Is there a way to link or group column C and G
so I can sort them as the same column?

 

[JE McGimpsey]

What I'm trying to do is make an order form that consists of 4 columns:
v - catalog # - title - price. But I'd like to see them twice on the
same page. So that my header row will show: v - catalog # - title -
price - v - catalog # - title - price. And I need to sort this
alphabetically by the title row.

I don't know if I can just adjust the page view somehow OR if I'll have
to have 8 rows. A - H. Is there a way to link or group column C and G
so I can sort them as the same column?

For headers, you can obviously use

E1: =A1
F1: =B1


etc. There's no real page view that can give you the display you want.
There are a couple of kludges I can think of, including using formulae
or the camera tool to display values from hidden rows (but I'm not sure
how you'd fill in the order in that case).

If you use 8 columns, to sort items by title will require a macro. This
could be an automated macro, triggered by a cell, or 4 cells being
filled in, or it could be manual.

In order to guess what would work, it would be helpful to have a bit
more description:

What should trigger the sort (e.g., filling in four cells, filling in
just one, manually clicking a button)?

Does the form have a limited number of rows, or should it grow with the
number of items. Is there anything in the rows below the entries?

Are all the cells manually entered, or are some of the items the result
of formulae?

Are entries to be made in either set of columns? somewhere else on the
form?