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

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
VLOOKUP not working with data from PeopleSoft 3
Function in Excel to count and list number of entries of text valuesin a row. 2
Index Match on Columns and Rows 0
COUNT rows on external sheet if between date range 3
I don't want row 1 as the column headings 1
VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row 3
Sumif 2 criteria - 1 in a Row and 1 in a Column 2

Top