View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wins007 wins007 is offline
external usenet poster
 
Posts: 5
Default Splitting records

Hi everybody,

I need some help to enable me working smarter and faster. I have a list
consisting of three columns which I need to convert in multiple rows as
follows.

A B C D
Tommy 500 75 575
Peter 100 15 115
Jane 800 120 920
Greg 200 30 230

The list should look as follows as it requires further processing

Tommy 500
Tommy 75
Tommy 575
Peter 100
Peter 15
Peter 115
Jane 800
Jane 120
Jane 920

The list may vary in number of lines.

Thank you for your guidance.