Split rows into columns?

[cubsfan334]

Hello,

I have a very long row of data in excel. I'd like to split it into 3 columns, like so:

A B C D E F G H I J K L

becomes

A B C
D E F
G H I
J K L

Because my row is around a thousand cells long, it would be nice to do this automatically. Is this possible?

Thank you,
Tom

[darkyam]

Assuming your data is in row 1, A2 could have =INDEX($1:$1,(ROW()-1)*3+COLUMN()-1). Drag across to column C and down as necessary. Then copy and paste as values, and delete D1:end of range.

[JeanRage]

Hi,

Among many possibilities, with Offset() function ...
See attached

HTH

[darkyam]

JeanRage, in general, it's better to avoid Offset when possible, as it's a volatile function. See here for a better explanation. Non-volatile Index or Index/Match combos can be used in place of Offset most, if not all, the time.

[JeanRage]

@ darkyam ...

Thanks for the info ...
Never had to deal with very large databases with volatile functions ...