Hi
Someone's help would be very appreciated. I have a list of addresses where there are multiple street names and all of them have a different house number in the cell to the left of street name. I would like all of the house numbers to come under the street name. I have removed duplicates of street names and transposed them from column to top row.
Below is an example of what I would like to happen (with a formula a bit like a vlookup or an array)
<tbody>
</tbody><colgroup><col span="7"></colgroup>
Someone's help would be very appreciated. I have a list of addresses where there are multiple street names and all of them have a different house number in the cell to the left of street name. I would like all of the house numbers to come under the street name. I have removed duplicates of street names and transposed them from column to top row.
Below is an example of what I would like to happen (with a formula a bit like a vlookup or an array)
How Data Looks | How would like data to look | |||||
Sheet 1 | Sheet 2 | |||||
Column E | Column F | Column A | Column B | Column C | Column D | |
House 1 | Street 1 | Street 1 | Street 2 | Street 3 | Street 4 | |
House 2 | Street 1 | House 1 | House 1 | House 1 | House 1 | |
House 3 | Street 1 | House 2 | House 2 | House 2 | House 2 | |
House 4 | Street 1 | House 3 | House 3 | House 3 | House 3 | |
House 1 | Street 2 | House 4 | House 4 | House 4 | House 4 | |
House 2 | Street 2 | House 5 | House 5 | |||
House 3 | Street 2 | |||||
House 4 | Street 2 | |||||
House 1 | Street 3 | |||||
House 2 | Street 3 | |||||
House 3 | Street 3 | |||||
House 4 | Street 3 | |||||
House 5 | Street 3 | |||||
House 1 | Street 4 | |||||
House 2 | Street 4 | |||||
House 3 | Street 4 | |||||
House 4 | Street 4 | |||||
House 5 | Street 4 |
<tbody>
</tbody><colgroup><col span="7"></colgroup>