I have a spreadsheet containing a list of Devices and their meters in Column A. Each device has a different number of meter runs associated with it. ex A1=Device , A2 = Meter 0, A3 = Meter 1 etc. Column B holds the Device name and the corresponding meter runs names. I need to take the device name and add that to Column C next to the corresponding meter runs for each device. I have attached a small sample to illustrate what the current worksheet looks like.
I have roughly 10,000 meter runs what would be the easiest way to accomplish what I need?
Thank you everyone for your help.Capture1.PNG
This is the link to the same post I asked on a different forum yesterday as well. Thanks
Bookmarks