In support of this question
https://excelribbon.tips.net/T008884..._Into_One.html

The full syntax of what Allen Wyatt is using is like …….
Cells(Rows.Count, 1).End(xlUp).Item(2) ……..
….
Item(2) will give us the cell just below the cell given by…….
Cells(Rows.Count, 1).End(xlUp) ………

Cells(Rows.Count, 1).End(xlUp) is the same as Cells(Rows.Count, 1).End(xlUp).Item(1) ………
……….
It is not to easy to explain how the items are assigned for a range……
See this demo
In the following demo, I show the item numbers for cells in four arbritrary ranges, A9 , B2:C3 , E5:G5 and D10:D12
As you will see, Item numbers are not restricted to just the range itself. The item numbers keep going. They go in a sequence of ... all columns in a row, ... then the next row ... etc....
The column count is determined by the original range, but the rows are not limited.


Row\Col
A
B
C
D
E
F
G
1
2
 Item(1) Item(2)
3
 Item(3) Item(4)
4
 Item(5) Item(6)
5
 Item(7) Item(8) Item(1) Item(2) Item(3)
6
 Item(9) ….etc… Item(4) Item(5) Item(6)
7
 Item(7) Item(8) Item(9)
8
 Item(10) ….etc….
9
 Item(1)
10
 Item(2) Item(1)
11
 Item(3) Item(2)
12
 Item(4) Item(3)
13
 Item(5) Item(4)
14
 Item(6) Item(5)
15
 …..etc…. Item(6)
16
 Item(7)
17
 Item(8)
18
 Item(9)
19
 Item(10)
20
 ….etc…
21