Search : in
By :

Moving data in a column in a 'circular' way

kikonas, on Nov 7, 2009 1:23:41 pm GMT 
 Report this message to moderators

Hello,

I have a column with data.I try to move down my data but the data that will exceed from the initial last cell of my column must be placed in the respective order in the cells on the top of my column that became empty after the move down.Is there any idea how this could be done?
Here is an example:

http://www.freeimagehosting.net/uploads/e3e46c3c61.jpg

(imagine this with hundred of numbers...,it is usefull when for example the left column is time(minutes) and you want to offset in time your incoming values)

Thanks in advance.

Best answers for « Moving data in a column in a 'circular' way » in :
Excel - COUNT # ROWS where 2 conditions are true ShowExcel - COUNT # ROWS where 2 conditions are true Issue Solution Note Issue I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active. here is the array: PR PRIORITY ACTIVE 1 2 Y...
Adding data from one column using another ShowAdding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
Download SQL Studio Data Compare Show
Download Windows Movie Maker ShowDescription: Windows Movie Maker is surprisingly easy and amusing for family realization of films, by allowing you to create, to edit and to share your films on your own computer by of simple slip move. You can add special effects, music and...
Spyware ShowSpyware Spyware refers to programs which gather information on the user of the computer they are is installed on, thenwhich is sent to the software's publisher so Internet users can be profiled. Data gathered this way may be: URLs of websites...
OOP - Data encapsulation ShowThe concept of encapsulation Encapsulation is a way of organising data and methods into a structure by concealing the the way the object is implemented, i.e. preventing access to data by any means other than those specified. Encapsulation...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Ask your question Reply
They need your help