Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with data parsing
Hi,
I have data which is in the format below called "Before Data" and I am trying to get it to "After Data" format. I can do some programming if given some advice. As you notice I am trying to repeat data from ID Long Lat 1 9.5 4 where 4 is number of times value 9.5 is included in Value column of after data. Any help would be appreciated. Before Data After Data ID Long Lat ID Long Lat Value 1 9.5 4 1 9.5 4 2 -118.727 37.81862 2 -118.727 37.81862 9.5 3 -118.728 37.81875 3 -118.728 37.81875 9.5 4 -118.731 37.81907 4 -118.731 37.81907 9.5 5 -118.735 37.81995 5 -118.735 37.81995 9.5 6 10.5 3 6 10.5 3 7 -118.743 37.82292 7 -118.743 37.82292 10.5 8 -118.744 37.82338 8 -118.744 37.82338 10.5 9 -118.748 37.8261 9 -118.748 37.8261 10.5 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with data parsing
Sorry this is how the data looks
Before Data ID Long Lat 1 9.5 4 2 -118.727 37.81862 3 -118.728 37.81875 4 -118.731 37.81907 5 -118.735 37.81995 6 10.5 3 7 -118.743 37.82292 8 -118.744 37.82338 9 -118.748 37.8261 After Data ID Long Lat Value 1 9.5 4 2 -118.727 37.81862 9.5 3 -118.728 37.81875 9.5 4 -118.731 37.81907 9.5 5 -118.735 37.81995 9.5 6 10.5 3 7 -118.743 37.82292 10.5 8 -118.744 37.82338 10.5 9 -118.748 37.8261 10.5 "Param Dhillon" wrote in message ... Hi, I have data which is in the format below called "Before Data" and I am trying to get it to "After Data" format. I can do some programming if given some advice. As you notice I am trying to repeat data from ID Long Lat 1 9.5 4 where 4 is number of times value 9.5 is included in Value column of after data. Any help would be appreciated. Before Data After Data ID Long Lat ID Long Lat Value 1 9.5 4 1 9.5 4 2 -118.727 37.81862 2 -118.727 37.81862 9.5 3 -118.728 37.81875 3 -118.728 37.81875 9.5 4 -118.731 37.81907 4 -118.731 37.81907 9.5 5 -118.735 37.81995 5 -118.735 37.81995 9.5 6 10.5 3 6 10.5 3 7 -118.743 37.82292 7 -118.743 37.82292 10.5 8 -118.744 37.82338 8 -118.744 37.82338 10.5 9 -118.748 37.8261 9 -118.748 37.8261 10.5 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with data parsing
Hi Param,
Is the data you present in the form of text is one long string or is it in an Excel layout already? Will these values be repeated over 9 times for each instance? Thanks, "Param Dhillon" wrote: Hi, I have data which is in the format below called "Before Data" and I am trying to get it to "After Data" format. I can do some programming if given some advice. As you notice I am trying to repeat data from ID Long Lat 1 9.5 4 where 4 is number of times value 9.5 is included in Value column of after data. Any help would be appreciated. Before Data After Data ID Long Lat ID Long Lat Value 1 9.5 4 1 9.5 4 2 -118.727 37.81862 2 -118.727 37.81862 9.5 3 -118.728 37.81875 3 -118.728 37.81875 9.5 4 -118.731 37.81907 4 -118.731 37.81907 9.5 5 -118.735 37.81995 5 -118.735 37.81995 9.5 6 10.5 3 6 10.5 3 7 -118.743 37.82292 7 -118.743 37.82292 10.5 8 -118.744 37.82338 8 -118.744 37.82338 10.5 9 -118.748 37.8261 9 -118.748 37.8261 10.5 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with data parsing
Hi David,
The data is allready in the excel format. If you look on my second thread its little more clear. Actaully 9.5 value will be repeated 4 times and the 10.5 value will be repeated 3 times in a new colum called value. PLease look under "After Data" and ID 1 and ID 6 Thanks Param After Data ID Long Lat Value 1 ,9.5 ,4 2 ,-118.727, 37.81862, 9.5 3 -118.728, 37.81875, 9.5 4 -118.731, 37.81907 ,9.5 5 -118.735, 37.81995 ,9.5 6, 10.5 ,3 7 -118.743, 37.82292, 10.5 8 -118.744, 37.82338, 10.5 9 -118.748 ,37.8261, 10.5 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with data parsing
Sorry but I am still having a difficult time visioning what you have as data.
The below is in 3 columns in Excel. I accoplished this by copying the data you had and using Data/Text to columns. This may not be what your data looks like currently in Excel. Then the other question was will the groups be repeated more than 9 times? ID Log Lat 1 9.5 4 2 -118.727 37.81862 3 -118.728 37.81875 4 -118.731 37.81907 5 -118.735 37.81995 6 10.5 3 7 -118.743 37.82292 8 -118.744 37.82338 9 -118.748 37.8261 OR it could look like this? Where the "repeated" number is combined with the number of repatitions? ID Log Lat 1 9.5 4 2 -118.727 37.81862 3 -118.728 37.81875 4 -118.731 37.81907 5 -118.735 37.81995 6 10.5 3 7 -118.743 37.82292 8 -118.744 37.82338 9 -118.748 37.8261 Thanks, "Param Dhillon" wrote: Sorry this is how the data looks Before Data ID Long Lat 1 9.5 4 2 -118.727 37.81862 3 -118.728 37.81875 4 -118.731 37.81907 5 -118.735 37.81995 6 10.5 3 7 -118.743 37.82292 8 -118.744 37.82338 9 -118.748 37.8261 After Data ID Long Lat Value 1 9.5 4 2 -118.727 37.81862 9.5 3 -118.728 37.81875 9.5 4 -118.731 37.81907 9.5 5 -118.735 37.81995 9.5 6 10.5 3 7 -118.743 37.82292 10.5 8 -118.744 37.82338 10.5 9 -118.748 37.8261 10.5 "Param Dhillon" wrote in message ... Hi, I have data which is in the format below called "Before Data" and I am trying to get it to "After Data" format. I can do some programming if given some advice. As you notice I am trying to repeat data from ID Long Lat 1 9.5 4 where 4 is number of times value 9.5 is included in Value column of after data. Any help would be appreciated. Before Data After Data ID Long Lat ID Long Lat Value 1 9.5 4 1 9.5 4 2 -118.727 37.81862 2 -118.727 37.81862 9.5 3 -118.728 37.81875 3 -118.728 37.81875 9.5 4 -118.731 37.81907 4 -118.731 37.81907 9.5 5 -118.735 37.81995 5 -118.735 37.81995 9.5 6 10.5 3 6 10.5 3 7 -118.743 37.82292 7 -118.743 37.82292 10.5 8 -118.744 37.82338 8 -118.744 37.82338 10.5 9 -118.748 37.8261 9 -118.748 37.8261 10.5 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with data parsing
'Start in cell D1
Sub Macro1() Do Until ActiveCell.Offset(0, -2).Value = "" ActiveCell.Offset(1, 0).Range("A1").Select LongLength = Len(ActiveCell.Offset(0, -2).Value) If LongLength = 0 Then End If LongLength < 6 Then RepeatNo = ActiveCell.Offset(0, -2).Value RepeatTimes = ActiveCell.Offset(0, -1).Value For Z = 1 To RepeatTimes ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.Value = RepeatNo Next Z Z = 0 Else End If Loop End Sub ID Long Lat (D1) 1 9.5 4 2 -118.727 37.81862 9.5 3 -118.728 37.81875 9.5 4 -118.731 37.81907 9.5 5 -118.735 37.81995 9.5 6 10.5 3 7 -118.743 37.82292 10.5 8 -118.744 37.82338 10.5 9 -118.748 37.8261 10.5 Hope this helps. "Param Dhillon" wrote: Hi David, The data is allready in the excel format. If you look on my second thread its little more clear. Actaully 9.5 value will be repeated 4 times and the 10.5 value will be repeated 3 times in a new colum called value. PLease look under "After Data" and ID 1 and ID 6 Thanks Param After Data ID Long Lat Value 1 ,9.5 ,4 2 ,-118.727, 37.81862, 9.5 3 -118.728, 37.81875, 9.5 4 -118.731, 37.81907 ,9.5 5 -118.735, 37.81995 ,9.5 6, 10.5 ,3 7 -118.743, 37.82292, 10.5 8 -118.744, 37.82338, 10.5 9 -118.748 ,37.8261, 10.5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing Data with | Excel Discussion (Misc queries) | |||
Help With Parsing Data | Excel Discussion (Misc queries) | |||
Parsing Data | Excel Discussion (Misc queries) | |||
Parsing Data | Excel Programming | |||
Parsing Data | Excel Programming |