Forum Discussion
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...
A small sample data would be helpful to understand you query, please manually type your desired result
Regards, Faraz Shaikh
Regards, Faraz Shaikh
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
- This video might be helpful for you
https://www.youtube.com/watch?v=W8g5jhYV-8M
Regards, Faraz Shaikh