You could do something like this:

*= Table 1

#+name: table1
| Manufacturer =C2=A0 =C2=A0| Name =C2=A0= =C2=A0 =C2=A0 =C2=A0| Price |
|-----------------+-------------+-------|=
| ACME =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| super cheep | 25 \$ = =C2=A0|
| Roadrunner Inc. | Kaboom =C2=A0 =C2=A0 =C2=A0| 27 \$ =C2=A0|| ACME =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| cheep =C2=A0 =C2=A0 =C2= =A0 | 30 \$ =C2=A0|

#+RESULTS: resorted
| Manufacturer =C2=A0 =C2= =A0| Name =C2=A0 =C2=A0 =C2=A0 =C2=A0| Price |
|-----------------+------= -------+-------|
| ACME =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| super= cheep | 25 \$ =C2=A0|
| ACME =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = cheep =C2=A0 =C2=A0 =C2=A0 | 30 \$ =C2=A0|
| Roadrunner Inc. | Kaboom =C2= =A0 =C2=A0 =C2=A0| 27 \$ =C2=A0|

** Code for resorting

#+name:= resorted
#+BEGIN_SRC emacs-lisp :var data=3Dtable1 :colnames t
(sort= data (lambda (row1 row2) (string< (first row1) (first row2))))
#+END= _SRC

John

---= --------------------------------
Professor John Kitchin=C2=A0
Doherty= Hall A207F
Department of Chemical Engineering
Carnegie Mellon Univer= sity
Pittsburgh, PA 15213
412-268-7803

On Thu, Oct 1, 2020 at 4:57 AM Axel Kielhorn <org-mode@axelkielhorn.de> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">Hello!

I have a table that I want to show with two different sorting orders but I = don=E2=80=99t want to maintain the data twice.

* Table 1

| Manufacturer=C2=A0 =C2=A0 | Name=C2=A0 =C2=A0 =C2=A0 =C2=A0 | Price |
|-----------------+-------------+-------|
| ACME=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | super cheep | 25 \$=C2=A0 = |
| Roadrunner Inc. | Kaboom=C2=A0 =C2=A0 =C2=A0 | 27 \$=C2=A0 |
| ACME=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | cheep=C2=A0 =C2=A0 =C2=A0= =C2=A0| 30 \$=C2=A0 |

*=C2=A0 Table 2

| Manufacturer=C2=A0 =C2=A0 | Name=C2=A0 =C2=A0 =C2=A0 =C2=A0 | Price |
|-----------------+-------------+-------|
| ACME=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | cheep=C2=A0 =C2=A0 =C2=A0= =C2=A0| 30 \$=C2=A0 |
| ACME=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | super cheep | 25 \$=C2=A0 = |
| Roadrunner Inc. | Kaboom=C2=A0 =C2=A0 =C2=A0 | 27 \$=C2=A0 |

Is there a way to do this in org?
Right now I copy the table and apply an =3DC-c ^ a=3D on the first column.<= br>
Greetings
Axel
--000000000000a8481a05b09b0ec8--