Hello

I have an excel with an "ID" column (A) and the data column (B). There
exist multiple entries (rows) for the same Id. Unfortunately they did
not multiply out the IDs with the value column means the same entries
are listed together but with no Id. Here an example:

A B
------------
11 DATA_A
12 DATA_B
DATA_C (no id belongs to ID 12)
13 DATA_D
14 DATA_E
DATA_F (no id belongs to ID 14)
DATA_G (no id belongs to ID 14)
15 DATA_H


How can I multiply it out? I like to have this result

A B
------------
11 DATA_A
12 DATA_B
12 DATA_C (no id belongs to ID 12)
13 DATA_D
14 DATA_E
14 DATA_F (no id belongs to ID 14)
14 DATA_G (no id belongs to ID 14)
15 DATA_H

Many thanks
regards

Mark Egloff