how do I convertext in cells a1, a2, a3 and covert to a1, b1, b2

[Guest]

I have addresses which were entered in cells a1, A2, A3 and so On and I need
to convert them to appear in cells a1, b2, b3 I know I have performed this
function in the past but I am drawing a blank please help.

 

[Barb Reinhardt]

Control R will the cell immediately to the left into the current cell.

 

[Max]

Just venturing a guess here (looking at your subject line) that perhaps what
you're after is to re-arrange "grouped" source data in a column to fit into
different separate columns

Assuming your data is in A1 down,
with the addresses in groups of 3 lines each, e.g.:

Add1_Line1
Add1_Line2
Add1_Line3
Add2_Line1
Add2_Line2
Add2_Line3
etc

Put in B1: =INDEX($A:$A,ROW(A1)*3-3+COLUMN(A1))
Copy B1 across 3 cols to D1, fill down until zeros appear,
signalling exhaustion of data extracted from col A

If required, freeze the values by selecting cols B to D,
then do an "in-place" copy > paste special > values > ok

Adapt this part: ROW(A1)*3-3
to suit the number of lines per group ..
(adapt also the "copying across" part accordingly)

 

[Max]

... The results in cols B to D will appear as:

Add1_Line1 Add1_Line2 Add1_Line3
Add2_Line1 Add2_Line2 Add2_Line3
etc