I have a table on sheet 1 as follows:
Name | Type | Number |
---------------------
x | 1 | av3 |
---------------------
y | 2 | bu4 |
---------------------
a | 1 | 23r |
---------------------
b | 1 | gk4 |
I need to separate the table into two separate sheets based on type, so type 1 is populated on sheet 2, and type 2 is populated on sheet 3.
Below is how I would like sheet 2 to be displayed:
Name | x |
-------------
Number| av3 |
-------------
| |
-------------
Name | a |
-------------
Number| 23r |
-------------
| |
-------------
Name | b |
------------
Number| gk4|
Below is how I would like sheet 3 to be displayed:
Name | y |
------------
Number| bu4|
------------
I am currently trying to use vlookup to reference the type and populate the data however vlookup will only find one match and will not find a the next match down. How do I get around this?