Append row data from 1 sheet to the end of a matching cell row

Closed
BobTelco
Posts
1
Registration date
Wednesday December 17, 2014
Status
Member
Last seen
December 17, 2014
- Dec 17, 2014 at 02:48 AM
If columnA in sheet2 matches columnB in sheet1, append the data from the row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple rows with the same column data and the data from sheet2 needs to be added to all sheet1 matching rows. ie:
Sheet1:
hr abc ddd rrt
hr dew ggg wqq
hr dew fff xxx

Sheet2:
abc ppp ooo
cdc jjj lll
dew mmm vvv

Sheet3:
hr abc fff rrt abc ppp ooo
hr dew ggg wqq dew mmm vvv
hr dew fff xxx dew mmm vvv

Thanks you any help...