Splitting data into multiple columns isn't the only way to rearrange data in Excel. For example, you could merge data from two columns into one column, split alternate rows into two columns, or ...

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Learn how to perform Excel multiple column lookups with ease using XLOOKUP, FILTER, SUMPRODUCT, and Boolean logic techniques.