| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PeopleSoft report spits out 1 row into 2 rows -how to make 1 row
Hello
My report on row 1 has product number and all the info Row 2 has the description How do I turn this into all one row. Also the report can have 2000 to 5000 rows to fix. -- Thanks much Sandyh |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
PeopleSoft report spits out 1 row into 2 rows -how to make 1 row
1. Suppose your data starts on Row 1, cell A1 then in B1 enter the formula
=IF(MOD(ROW(),2)=1,A2,NA()) 2. Copy this formula down as far as your data extends. 3. Select all the formula cells in column B and choose Copy 4. Choose Edit, Paste Special, Values, OK 5. With the column B data still selected press F5, Special, Constants and uncheck all but Errors, and click OK. 6. Press Ctrl+- (control minus) and pick Entire Row. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Sandyh" wrote: Hello My report on row 1 has product number and all the info Row 2 has the description How do I turn this into all one row. Also the report can have 2000 to 5000 rows to fix. -- Thanks much Sandyh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make cell report zero if it's a negative number | Excel Discussion (Misc queries) | |||
| Make a report with more lines that you can see on the screen | Excel Discussion (Misc queries) | |||
| I'd like to make a report card . | New Users to Excel | |||
| I'd like to make a report card . | Excel Discussion (Misc queries) | |||
| How do I make a productivity report? | Excel Worksheet Functions | |||
Hybrid Mode
