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

  • Thread starter Thread starter Sandyh
  • Start date Start date
S

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.
 
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.
 
Back
Top