erm87
New member
- Joined
- Apr 13, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hello everyone,
Background: I have a set of .txt data I've imported into Excel. It came off a R232 serial port of a Fire Alarm Panel and isn't formatted in comma or tab or even a space delimited pattern. However it is consistently spaced (5 rows between data sets). Each little group (5 rows) of information is for a single Device on the system (ex. Smoke Detector) that has an Device Address, Type, and Description.
Problem: I'm trying to find, with no luck so far, a formula I can fill down that will take into account the spaced pattern.
What I've Tried: Well, being dumb, I first tried doing the first three devices by simple references and seeing if Excel would recognize the pattern -- Nope.
I then tried using the Offsets command but that didn't work either -- it doesn't compound the offset amounts.
Goal: If I can get the devices into a nice list, I can then export a .csv to the Fire Alarm program and not have to manually enter each device (there are over 700 in total!). I've attached the Excel file if that may be of service to anyone able point me in the right direction.
Background: I have a set of .txt data I've imported into Excel. It came off a R232 serial port of a Fire Alarm Panel and isn't formatted in comma or tab or even a space delimited pattern. However it is consistently spaced (5 rows between data sets). Each little group (5 rows) of information is for a single Device on the system (ex. Smoke Detector) that has an Device Address, Type, and Description.
Problem: I'm trying to find, with no luck so far, a formula I can fill down that will take into account the spaced pattern.
What I've Tried: Well, being dumb, I first tried doing the first three devices by simple references and seeing if Excel would recognize the pattern -- Nope.
I then tried using the Offsets command but that didn't work either -- it doesn't compound the offset amounts.
Goal: If I can get the devices into a nice list, I can then export a .csv to the Fire Alarm program and not have to manually enter each device (there are over 700 in total!). I've attached the Excel file if that may be of service to anyone able point me in the right direction.