Changing Collumnar fields to row fields

  • Thread starter Thread starter Craig Harding
  • Start date Start date
C

Craig Harding

I run into, regularly, scenarios whereby I am writing data
exchanges between two apps (payroll). For instance a
timesheet may have the following format where Collumn "A"
holds the employee # and "B" holds reg earnings code, "C"
holds the value associated with "B". "D" holds OT Earnings
code and "E" holds OT value...etc etc for other earnings
types or codes. I am needing to reformat this to show a
maxof one earnings code and its associated value per row
(along with the employee #). So if there are additional
earnings codes associated with an employee these would be
listed seperately (along with the employee #) on
additional rows.

So source might look as follows:

Header: EE#|Reg Code|Reg Value|OT Code|OT Value|
Row 2: 3 | 1 | 45 | 2 | 8 |
Row 3: 5 | 1 | 37.5 | 2 | 5 |

The headerless results I am looking for from this should
look like:

Row 2: 3 | 1 | 45 |
Row 3: 3 | 2 | 8 |
Row 4: 5 | 1 | 37.5 |
Row 5: 5 | 2 | 5 |

Any ideas?
 
The TRANSPOSE formula will change vertical arrays to horizontal and vis
versa.

The formula must be entered as an array formula. Start with the
formula cell. Press F2, and then press CTRL+SHIFT+ENTER. If the formul
is not entered as an array formula, the single result is
 
Back
Top