Question description:
This user has given permission to use the problem statement for this
blog.
i need to merge column from 3 workbooks without a unique identifier
Solved by F. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
19/02/2018 - 04:40
hi welcome to got it pro
Excelchat Expert
19/02/2018 - 04:40
i will be able to assist you with your query,..
Excelchat Expert
19/02/2018 - 04:42
hi dear if i suggest u for more accuracy purpose i would suggest following formulae
Excelchat Expert
19/02/2018 - 04:43
- col_index_num
Excelchat Expert
19/02/2018 - 04:43
index Match,..
Excelchat Expert
19/02/2018 - 04:43
r u there dear
User
19/02/2018 - 04:43
yes
Excelchat Expert
19/02/2018 - 04:44
do u have have raw sheet that u can upload pls
User
19/02/2018 - 04:44
no
Excelchat Expert
19/02/2018 - 04:44
no worries
Excelchat Expert
19/02/2018 - 04:45
so in order to address your query,.. the above formulae that i have given will be most helpful and suitable
Excelchat Expert
19/02/2018 - 04:46
do you want e to share Index match,. raw dum sheet,..
Excelchat Expert
19/02/2018 - 04:46
which will help u for future refrence
User
19/02/2018 - 04:46
can u show quick example
Excelchat Expert
19/02/2018 - 04:46
ye spls
Excelchat Expert
19/02/2018 - 04:47
let me upload for u
Excelchat Expert
19/02/2018 - 04:48
Have a look pls
[Uploaded an Excel file]
Excelchat Expert
19/02/2018 - 04:48
there are two sheet ,.. where there is a working of Index Match formulae
Excelchat Expert
19/02/2018 - 04:50
you also want to read more about the stuff from this Link Pls
Excelchat Expert
19/02/2018 - 04:50
https://support.office.com/en-us/article/consolidate-data-in-multiple-worksheets-007ce8f4-2fae-4fea-9ee5-a0b2c9e36d9b
Excelchat Expert
19/02/2018 - 04:50
from Microsoft,..
Excelchat Expert
19/02/2018 - 04:51
does this Help dear
User
19/02/2018 - 04:52
i am going to look at it when i am done with with. would data query work?
Excelchat Expert
19/02/2018 - 04:52
yes definetly
Excelchat Expert
19/02/2018 - 04:54
dear in your particular scenario,. you can find en number of solution,..its just what content you want on ur final sheet
Excelchat Expert
19/02/2018 - 04:55
data Quey would work best with,.. column and table,.. they are more authentic,..
User
19/02/2018 - 04:55
my preferred method s vlookup, however one of the workbook doesnt have headers, is it possible because i have tried some many ties
User
19/02/2018 - 04:55
i mean times
Excelchat Expert
19/02/2018 - 04:56
dear,.. it should not effect you,.. all you need in sheet is common value ,.. and Vlookup will definetly work,...
Excelchat Expert
19/02/2018 - 04:57
reason,. Vlook up work with,.. common value,.. in sheets
User
19/02/2018 - 04:58
i don't have common values, just want to move 2 colmuns from one to the next, its a very large data
User
19/02/2018 - 04:59
any other suggestion, thanks
Excelchat Expert
19/02/2018 - 04:59
so in that case,..first create,.. new column
User
19/02/2018 - 05:00
my time is up , thanks
Excelchat Expert
19/02/2018 - 05:00
and simply cut and paste,..
Excelchat Expert
19/02/2018 - 05:00
I hope my given suggestion might help you,.. thanks for contacting Got itPro,.. happy learning
Excelchat Expert
19/02/2018 - 05:01
TC
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.