Hi! I have an excel sheet that contains 3 columns of numerical data. I need to consolidate Column A & C and match the data in column B to the respective A & C rows without adding the data in Column B together.
Thanks!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Consolidate 2 of 3 without summing 3rd
0
Discussion
Not clear. I suggest you create a workbook with data as they are and a manually created sample of the data as you want them. You can attach that workbook to your original question if you press Edit and then look for the buttons to add attachments at the bottom of the screen.
Variatus (rep: 4889) May 5, '20 at 9:27 pm
Answers
0
If by 'consolidate' you simply mean to bring both sets of data together within the same cell, this is easily done by using '&'. For example, if you have 1 in A1 and 2 in C1, enter =A1&C1 into D1 and the cell will read 12