1Answers
The excel table arranges the same content in the same row
Asked by: Gary Walker 136 views Software
I have two tables. I want to make a comparison. How can I arrange the data in Table 2 into the order of names in Table 1, without changing the data behind Table 2, as shown in the figure.
Addition: Table 1 and Table 2
+6Votes
Sorting table one and table two by name, copy and cover the sequence number column of table one to the sequence number column of table two, and then sort by the sequence number column.