excel macro

[writetoevv]

excel problem definition has been described briefly in the below snapshot.

https://www.dropbox.com/s/0v7duejb726laws/dear mumps.jpg?dl=0

Thanks & regards.

 

[mumps]

Did we not solve your problem in a previous thread?

 

[Rick Rothstein]

Here is a macro that you can try...

[table="width: 500"]
[tr]
	[td]Sub DistributeOddEven()
  Dim Arr As Variant
  Arr = Range("A2", Cells(Rows.Count, "A").End(xlUp))
  Range("D2").Resize((1 + UBound(Arr)) / 2) = Application.Index(Arr, Evaluate("2*ROW(1:" & UBound(Arr) & ")-1"))
  Range("E2").Resize(UBound(Arr) / 2) = Application.Index(Arr, Evaluate("2*ROW(1:" & UBound(Arr) & ")"))
End Sub[/td]
[/tr]
[/table]

 

[writetoevv]

Hi mumps,

csv doesnot support telugu language..so we cannot do anything with CSV..
however, we are good with excel..that is fine..

Now, i have been working on multiple scenarios of data handing with excel programming. Thus created a new thread.
appreciate for your reach out..

 

[writetoevv]

Thank you, Rick..Let me check..

Edit: Worked like a charm..

 

[writetoevv]

Hi Rick

These days, i have been getting data in excel in a slightly different way

1. below link gives an idea of problem definition
https://www.dropbox.com/s/95m8fhovqh8nmgl/Problem Definition with Initial Data in Column A.jpg?dl=0

2. below link helps to get an idea how data should appear after running macro
https://www.dropbox.com/s/ti76xjayth4gi1t/Final Output After running macro.jpg?dl=0


Note: 1. Rows with no data should not be present in final output of excel
2. row with garbage should not be present in final output of excel

 

[writetoevv]

Hi Rick & Friends,

Could you please help on above problem definition

Thanks & Regards