Forum Discussion

zwernick's avatar
zwernick
Copper Contributor
Aug 07, 2022

Merging Tables

I have two sheets. Sheet2 has 1741 rows and Sheet1 has 324. Sheet1 column A has id numbers that all exist in Sheet2 column D. I want to append the text cells (Columns $B:$H) from sheet1 to the matchi...
excel
office 365
zwernick's avatar
zwernick
Copper Contributor
Aug 07, 2022

Sheet1:

receipt-number, customerid, name of piped customer, value date, amount, comments, name on receipt
ex:
1, 12345, Smith John, August 7, $500, for project X, ABC Inc
4, 56789, Smith Jane, August 3, $100, for project Y, XYZ Inc
7, 12345, Smith John, August 2, $500, for project X, W Inc

Sheet2:
A, B, C, D
name, receipt date, receipt name, receipt number, columns E-AJ have additional data pieces
row 2 starting with Receipt number (column d)
1
2
3
4
5
6
7

solution should be on sheet2: D, Columns AK+
1 ,12345, Smith John, August 7, $500, for project X, ABC Inc
2, AK+ leave blank
3. AK+ leave blank
4, AK=56789, Smith Jane, August 3, $100, for project Y, XYZ Inc

Resources