Welcome Guest.


The excel table arranges the same content in the same row

Asked by: Gary Walker 136 views Software January 28, 2021

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

1 Answers

  1. +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.

    Scott Murray- January 28, 2021 |