locked
Need to change the form RRS feed

  • Question

  • I need to change form to the next worksheet:

    current form:

    PERFORMANCE_MEASURE_201551 PRODUCTPAYOUT_201551 PERFORMANCE_MEASURE_201550 PRODUCTPAYOUT_201550
    Customer Value Feedback 1 Operating Profit 10
    Customer Value Feedback 1.58 Operating Profit 20

    need to convert into to the next worksheet:

    Customer Value Feedback 1
    Operating Profit 10
    Customer Value Feedback 1.58
    Operating Profit 20

    Format is:

    Monday, August 13, 2012 12:13 PM

Answers

  • On the second sheet, in cell A2, enter the formula

    =INDEX(Sheet1!A:D,INT(ROW()/2),1+2*(INT(ROW()/2)<>(ROW()/2)))

    and copy down and over until all your data is included.

    Monday, August 13, 2012 2:53 PM