Breaking down ranges into individual rows.

thankyoufromme

New Member
Joined
Dec 21, 2016
Messages
5
This is a simpler version of something that is much bigger, how do I break down data in excel from this format to this format?

ID TagID
400 1:5
483 E21.3:E21.5

ID TagID
400 1
400 2
400 3
400 4
400 5
483 E21.3
483 E21.4
483 E21.5
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,114,523
Messages
5,548,547
Members
410,848
Latest member
anuradhagrewal
Top