Creating Header and Detail records from a single row

R

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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
You must log in or register to reply here.

Similar threads

B
  • Solved
Populating combobox from table based on the header selected in another combobox (some data on different sheets)
Replies
7
Views
233
BWL388
B
I
  • Question
Move multiple rows from one table to another using conditional trigger
Replies
2
Views
465
ItsNursinTime
I
D
  • Solved
Keep only 12 rows of data in an excel table
Replies
4
Views
201
Peter_SSs
Peter_SSs
C
  • Solved
Ladder League Workbook, replace one row with another
Replies
2
Views
237
CordingBags
C
A
  • Question
VBA to Split Data From an Existing Table into Another Single Worksheet with Header for Each Section
Replies
1
Views
179
John_w
J

Forum statistics

Threads
1,214,833
Messages
6,121,865
Members
449,052
Latest member
Fuddy_Duddy

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top