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. Sheet 1 displays the current data set and sheet 2 contains what the solution data set should look like.
I have roughly 10,000 meter runs what would be the easiest way to accomplish what I need?
Here is the only other place I have posted the same/similar question. https://www.excelforum.com/exc…column-a.html#post5192600
Thank you everyone for your help.