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

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