Create two rows based on one row

[Guest]

A worksheet has information in a single row. The new worksheet has columns. How can I create two rows per column in this new worksheet, based on information from the single row (key=document number, same amount for debit- and credit - but in a different row, accounts based on table) .

 

[Frank Kabel]

Hi
not really sure about your spreadsheet layout. Could you post an
example (plain text - no attachment please) and describe your expected
result based on this example

 

[Frank Kabel]

hi
how do you get the distribution account#?

--
Regards
Frank Kabel
Frankfurt, Germany

first sheet, information is stored in 1 row:
document number|Date |customer id|currency

id|amount|checkbook id|business unit id|

12345 |05/25/2004|TEST01 |USD |100.00

|RBTT |CUR |

second sheet, information has to be stored into columns:
document number|distribution account|distribution type|debit

amount|credit amount|business unit|checkbook id|

12345 |000-1111-00 |CASH |

100.00 | | |RBTT |

12345 |000-1150-00 |RECV |

| 100.00 | CUR | |

debit and credit amount is the same amount, but has to be in a

separate row, distribution account and type is based on business unit
and checkbook id (lookup table)

 

[Guest]

debit and credit amount is the same amount, but has to be in
separate row and column, distribution account and type is based on business uni
and checkbook id (lookup table

 

[Frank Kabel]

Hi Toni
if you want a specific macro solution for this 8or a formula approach)
you may provide complete information/details:
- what lookup table
- how to lookup
- etc-