Is it possible to transfer particular type of data from a coloumn to a particulars cell ?

Question

In a sheet in coloumn A there are 4 names - x,y,z,x. There are 3 another sheet assigned to the above there names i.e. X,Y,Z. How to transfer the two details of X to the sheet assined to its name ?

Answer 1

Split the four names in column A to columns B, C, D, and E. You can do this by using the string functions to pull the data out between the commas. Place them into the appropriate columns so that x1 goes into B, y into C, z into D, and x2 into E.

You will need four sheets named input, X, Y, and Z. From input, copy and paste columns B and E into the appropriate columns in Sheet X. You can do it with formulas too.