Posts by nalina

Re: Move data from multiple columns copying 1st column each time

It works! Thank you so much!

Re: Move data from multiple columns copying 1st column each time

trunten
Thank you!
Is there an automated way to get rid of zero-values? Not the filter ))

Re: Move data from multiple columns copying 1st column each time

or macros

Sub Kwijibo()
 
application.screenupdating = false
sheets("results").activate
range("a1").activate
sheets("input").activate
range("a1").activate
 
while activecell.value <> ""
 
n=1
label = activecell.value
 
 
while selection.offset(0,n) <> ""
item = selection.offset(0,n)
sheets("results").activate
activecell.value = label
selection.offset(0,1).value = item
selection.offset(1,0).select
sheets("input").activate
n=n+1
wend
 
selection.offset(1,0).select
 
wend
 
application.screenupdating = true
 
end sub

Both of them do not put year into separate column

Re: Move data from multiple columns copying 1st column each time

If possible, to move only units >0, so that zero sales do not display at output page

Actually, I have searched e-net a lot. What I found is
formula
=INDEX($B$5:$D$26,MOD(ROWS(F$2:F3)-1,ROWS($B$5:$D$26))+1,INT((ROWS(F$2:F3)-1)/ROWS($B$5:$D$26))+1)

Here is a sample

Re: Move data from multiple columns copying 1st column each time

Oh sorry
Just a moment

Hi All,

The data are arranged into 4 columns, 1st - product. 2nd - 2010 sales, 3 - 2011 sales, 4 - 2012 sales. How to re-arrange the table so that I have only these columns - product, year and units/revenue. Do you know macros or/and formula?