Forum Discussion
database
Dear sir/madam,
I seeking support on excel, I have customer data in so many excel files. issue is one excel sheet if the customer name is A, contact number in B and email ID is in C. in other excel file customer name is C, contact number in B and email ID is in A. I want organize these data in one excel file.
- You could place all files into a single Workbook, then on a blank sheet copy all the names into a single column, and then use either VLOOKUP or XLOOKUP functions to lull all data together. Then once all the data you wish to combine, you can hide those sheets so only tab that has all data appears.
If you are familiar with Power Query, that would be the best way to capture and organize data from different data sources.
Hope this helps.
