Distribute data from different cells of a column to individual column's cell

[Uzzal]

Hi! I have a bulk data containing date, invoice no. & value in three respective cells (one after another) of a single column. Is it possible to segregate all these three items in three different column ? Please help.(The concern sheet attached for your contemplation)
Invoice No & Date
and Value

117/2013
27/01/2013
4,229.84
364-2013
25/02/2013
1,850.55
430/2013
26/05/2013
82,120.38

 

[Somendra Misra]

Hi Uzzal,

What is 4 in D11 cell? And the order is same as Invoice #, Date & amount for the entire data set? Are there blanks cells in between your data as in your sample file and if so can they be removed and batches can be formed.?

Regards,

 

[Uzzal]

Hi Uzzal,

What is 4 in D11 cell? And the order is same as Invoice #, Date & amount for the entire data set? Are there blanks cells in between your data as in your sample file and if so can they be removed and batches can be formed.?

Regards,

Hi Somendra! Good to see you there.Ignore 4 in D11 cell,Order is same,blank cells removed, I don't know how to work with batches. revised file has uploaded for you contemplation

 

[Somendra Misra]

@Uzzal,

See the file, light green cells has formula.

Regards,

 

[Uzzal]

@Uzzal,

See the file, light green cells has formula.

Regards,

Yes I got it Somendra, seems like you know lot of ninja technics, by the way, should I input the formula manually all the down way, when I would like to set the following data after every two cell down worth, so that I can remove the date & value Row from behind the Invoice no. row as they would be furnished beside the invoice numbers respectively ? Please see the file.

 

[Somendra Misra]

@Uzzal

I doubt what you are saying is possible, because if you drag a formula down the ref. adjust automatically based whether the references are relative or partial relative. If you delete the rows they will auto adjust automatically.

I will suggest you to arrange your data in a different manner.

Regards,