Hi All
I am trying to join two tables that are not similar in nature (vertical data vs horizontal data) and also dont share any row or column headers.
Based on the contact sheet and product sheets attached is it possible to arrive at the finished report while maintaining the blank row separating the tables?
| Sheet | Product Name |
| Contact | Phone Number |
| Contact | Email |
| Manager | Name |
| Manager | Email |
| Contact | Group Distro |
| Transfer | Type |
| Price | Quantity | Product | Net | State | City | Time | Location | Distance | Temp |
| $ 6.50 | 6 | Apple | $ 39.00 | Alabama | Montgomery | 1:00pm | Southeast | Far | Hot |
| $ 7.50 | 7 | Orange | $ 52.50 | | Juneau | 2:00pm | | Far | Cold |
| $ 8.50 | 8 | Pear | $ 68.00 | Arizona | Phoenix | 3:00pm | Southwest | Far | Hot |
| $ 9.00 | 9 | Grape | $ 81.00 | Arkansas | Little Rock | 4:00pm | Southeast | Far | Hot |
| $ 10.50 | 10 | Candy | $ 105.00 | California | Sacramento | 5:00pm | West | Far | Hot |
| $ 11.50 | 11 | Popcorn | $ 126.50 | Colorado | Denver | 6:00pm | West | Far | Warm |
| Sheet | Product Name | | | | | | | | |
| Contact | Phone Number | | | | | | | | |
| Contact | Email | | | | | | | | |
| Manager | Name | | | | | | | | |
| Manager | Email | | | | | | | | |
| Contact | Group Distro | | | | | | | | |
| Transfer | Type | | | | | | | | |
| | | | | | | | | | |
| Price | Quantity | Product | Net | State | City | Time | Location | Distance | Temp |
| $ 6.50 | 6 | Apple | $ 39.00 | Alabama | Montgomery | 1:00pm | Southeast | Far | Hot |
| $ 7.50 | 7 | Orange | $ 52.50 | | Juneau | 2:00pm | | Far | Cold |
| $ 8.50 | 8 | Pear | $ 68.00 | Arizona | Phoenix | 3:00pm | Southwest | Far | Hot |
| $ 9.00 | 9 | Grape | $ 81.00 | Arkansas | Little Rock | 4:00pm | Southeast | Far | Hot |
| $ 10.50 | 10 | Candy | $ 105.00 | California | Sacramento | 5:00pm | West | Far | Hot |
| $ 11.50 | 11 | Popcorn | $ 126.50 | Colorado | Denver | 6:00pm | West | Far | Warm |
Thank you
