LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete records when certain records have duplicate column data JVroom New Users to Excel 1 January 26th 09 06:23 PM
Using vb to paste records from 1 sheet, to related records in another chrisnichols87 Excel Programming 0 January 10th 07 10:59 AM
Splitting appointment records in to 15 minute time bands The Inquirer Excel Worksheet Functions 4 October 9th 06 02:38 PM
Splitting appointment records in to 15 minute time bands The Inquirer Excel Discussion (Misc queries) 3 October 9th 06 12:30 PM
draw 999 x 8 random records from file with 8614 records news.wanadoo.nl Excel Programming 1 March 1st 06 03:04 PM


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"