I have two tables. Both tables have a leading column with names, then other columns with data associated with those names. the second table has fewer names than the first table, although both tables are from the same population (the names in the second table are all found in the first column)I want to find a way to have Excel automatically align the rows from table 2 with the corresponding row in table 1. For instance, if John Smith and his associated data is on row 5 in table 1, I want Excel to find John Smith in Table 2, then move him and his associated data to row 5, so that all John Smith's data is aligned. Is there a way to do this?
Bookmarks