Creating Header and Detail records from a single row

ricec

New Member
Joined
Jan 22, 2010
Messages
1
I have a file with PO Header and PO Detail information on the same row. The subsequent row may have the same header but different detail information.

I wish to create a sheet with the format

Row 1 - Header (Original Row 1)
Row 2 - Detail (Original row 1)
Row 3 - Detail (Original row 2) Header information is the same as header 1 therefore ignored
Row 4 - Header (Original Row 2)
Row 5 - Detail (Original row 2)

Can anyone suggest a way that this can be created
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Watch MrExcel Video

Forum statistics

Threads
1,109,304
Messages
5,527,912
Members
409,792
Latest member
shawnash

This Week's Hot Topics

Top