Excel 2007 : Move cells from right to left in a table ?

[eriol]

Hell everyone.

Is there any way that I can move data (with formula) in excel table from right to left but only non-zero cells ?

I know that it is not quite clear what I wanted to do from my description so I added example file in the attachment.

I managed to this with some array formula I found on the web but for some reason it worked only once !?



regards, eriol

[ajaykgarg]

Hi

Hope you know that to see output of array formula, you need to select the cell and hit Shift, Ctrl and Enter keys together?

hth
Ajay

[eriol]

Thx for your quick answer.

Yes I do. I take care to press all the keys. But that formula perplexed me because it worked on some tables but not on other for no obvious reason (to me at least) so I abandoned it all together and decided to search for other solution.

regards, eriol