Reformat spreadsheet

[Guest]

Hi everyone

I'm trying to change the format of a spreadsheet to repeat data in certain
cells. My format is currently:

Column C Column D

Part Number Description
Document Number Blank
Document Number Blank
Blank Blank
Part Number Description
Document Number Blank
Blank Blank

What I'd like is to copy the Part Number and Description from Columns C and
D and place them in Columns A and B, repeating as below:

Column A Column B Column C
Column D
Part Number Description Part Number
Description
Part Number Description Document Number Blank
Part Number Description Document Number Blank
Blank Blank Blank
Blank
Part Number Description Part Number
Description
Part Number Description Document Number Blank
Blank Blank Blank
Blank

I have different amounts of document numbers per part number, so it's very
random. I've tried various IF statements, but nothing can take into account
the blanks and the random amount of document numbers.

If anyone can help with a function or some code I'd be very grateful.

 

[Roger Govier]

Hi
In A1 enter
=IF(OR(LEFT(C1)="P",LEFT(C1)="D"),"Part Number","")
in B1 enter
=IF(OR(LEFT(C1)="P",LEFT(C1)="D"),"Description","")
Copy down as far as required