I have four Sheets with the below info:
Worksheet 1:
A1: Name B1:aaa
A2: Place B2:bbb
A3: Animal B3:ccc
A4: Thing B4:ddd
All the sheet has only two column of data and Column A has heading in four rows. Only the column 2 changes in each work Sheet.
How do I get this into the master Sheet with each sheet info on next column. Please See below what I want
A1: Name B1:aaa(from Sheet1) C1:asd(from Sheet2)
A2: Place B2:bbb(from Sheet1) C2:dff(from Sheet2)
A3: Animal B3:ccc (from Sheet1) C3:cjd (from Sheet2)
A4: Thing B4:ddd (from Sheet1) C4:tyu (from Sheet2)
etc. Can you please help. Thanks!
Bookmarks