0
I have data which is compiled into multiple excel files, all in simple two column x y format. All x values are identical, so I am looking for a way to combine them into one spreadsheet with x y1 y2 y3, etc. Example below: Merge/Copy Columns
Please, no Add-Ins if possible. I have searched for quite some time to find a solution to this, there can be over 100 at one time so it is very time consuming! I currently go through Data-Get External Data-From Text and select the next file.
Rachel
Posted 2016-10-20T13:45:55.133
Reputation: 1
In the first sheet, use a VLOOKUP that refers to the second sheet data. – Scott Craner – 2016-10-20T13:47:34.627
I can't quite figure out how to manipulate that for what I want since there are so many data points. Could you elaborate? – Rachel – 2016-10-20T14:01:48.647
In C2 on the first sheet
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)Then copy/fill down the length of the data. – Scott Craner – 2016-10-20T14:03:16.653New problem: Is there any way to allow Sheet2! to recognize CSV files? Unfortunately all of the files are CSV and I have not found any way to convert them other than Save As – Rachel – 2016-10-20T14:26:32.513
New problem = new question. – Scott Craner – 2016-10-20T14:27:46.357