Example of data:
John Doe
Some street
1234567890
Joanna Doe
Sesame street
654321
Expected result:
John Doe Some street 1234567890
Joanna Doe Sesame street 654321
Data on A1 to A6
Formula on B1:
=INDEX($A$1:$A$6;ROWS(A$2:A2)*3-3+COLUMNS($A2:A2))
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment