Hi guys,
I have the following two excel sheets:
Sheet A
| id |
| 1 |
| 2 |
| 3 |
Sheet B
| Product | id |
| Table | 2 |
| Book | 2 |
| Phone | 1 |
|Table | 1 |
| Phone | 2 |
| Phone | 3 |
What I am trying to achieve is this:
._extend Sheet A
| id 1 | | id 2 | id 3 |
| Table | Table | Phone
| Book |
| Phone |
Could you please assist me?
An excel formula only solution would be best. (without VBA)
Best,
Kjuby
I have the following two excel sheets:
Sheet A
| id |
| 1 |
| 2 |
| 3 |
Sheet B
| Product | id |
| Table | 2 |
| Book | 2 |
| Phone | 1 |
|Table | 1 |
| Phone | 2 |
| Phone | 3 |
What I am trying to achieve is this:
._extend Sheet A
| id 1 | | id 2 | id 3 |
| Table | Table | Phone
| Book |
| Phone |
Could you please assist me?
An excel formula only solution would be best. (without VBA)
Best,
Kjuby