Thread: TRANSPOSE a row to Uneven column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default TRANSPOSE a row to Uneven column
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.
Reply With QuoteReply With Quote