VBA excel programming : [![output sheet][1]][1]


[![The sheet from which data has to be dumped.][2]][2]

There is an excel sheet with ItemId and ItemName.For a single ItemID there are 4-5 ItemName.The data from this sheet needs to be dumped into another sheet using VBA Excel Programming.
The sheet in which the data is dumped shall list the ItemName in different columns for a single ItemId.

  [1]: http://i.stack.imgur.com/Fx3da.png
  [2]: http://i.stack.imgur.com/rJy9w.png