[[email protected]]

Hi,

I would like to ask if its possible to transpose a row
to an uneven column

for instance

1
2
3
4
5
6
7

make it

1 2 3
4 5 6
7


Thank you

--
§K³dÁn©ú http://disclaimer.nma.com.tw/

[Ron Rosenfeld[_2_]]

On Mon, 27 Oct 2014 21:51:52 -0700 (PDT), wrote:

Hi,

I would like to ask if its possible to transpose a row
to an uneven column


Yes, it is possible.
You can either use a VBA macro or a formula.

For a formula, in some cell enter:

=IF(INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:A))="","",INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:A)))

Fill right three columns; then select and fill down as far as required.

The *3 factor is how many columns across for your "transposition".

The formula: ROWS($1:1)-1)*3+COLUMNS($A:A) calculates which row form column A to return.