Simplified example of what I am trying to solve.
Data I have:
Column A / Column B
1 1
2 3
3 <blank>*
4 5
<blank> 7 *
5 *
9 *
* 7
10 9
* 11
<blank>
End result I require:
1 1
2 *<blank>
3 3
4 *
<blank> 5 5
7 7
<blank> 9 9
10 *
* 11
where *<blank> represents an empty cell
It lines up the data that matches, and when there is no match it leaves a blank in the column that doesn't have the data.
One issue is - either column could have more rows of data on a given day (eg. column A has 15 rows and column B has 10 rows on Monday, column A has 12 rows and column B has 15 rows on Tuesday).
Any help would be great appreciated.
Thank you.</blank></blank></blank></blank></blank></blank></blank>
Data I have:
Column A / Column B
1 1
2 3
3 <blank>*
4 5
<blank> 7 *
5 *
9 *
* 7
10 9
* 11
<blank>
End result I require:
1 1
2 *<blank>
3 3
4 *
<blank> 5 5
7 7
<blank> 9 9
10 *
* 11
where *<blank> represents an empty cell
It lines up the data that matches, and when there is no match it leaves a blank in the column that doesn't have the data.
One issue is - either column could have more rows of data on a given day (eg. column A has 15 rows and column B has 10 rows on Monday, column A has 12 rows and column B has 15 rows on Tuesday).
Any help would be great appreciated.
Thank you.</blank></blank></blank></blank></blank></blank></blank>