Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reformat spreadsheet
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reformat spreadsheet
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 -- Regards Roger Govier "JoP" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reformat Table | Excel Discussion (Misc queries) | |||
Reformat of a table | Excel Discussion (Misc queries) | |||
reformat a cell from last name, first to first space last? | Excel Discussion (Misc queries) | |||
reformat columns to rows? | Excel Worksheet Functions | |||
REFORMAT A TEXT CELL | Excel Discussion (Misc queries) |