PeopleSoft report spits out 1 row into 2 rows -how to make 1 row

[Sandyh]

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.

 

[Shane Devenshire]

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.