close

I have data (about 60x25) with each column having data for
particular expenses, but not all expenses. I want to arrange
the data so each row only has that particular expense.

My Data:

EXP #HOUSE A HOUSE B HOUSE C
Exp#$Exp#$ Exp# $
1110.00 2$16.001$20.00
225.00 4$18.003$15.00
3412.00
4

I want a report to look like:

EXP #HOUSE A HOUSE B HOUSE C110.00 20.00
2 5.00 16.00
3 15.00
412.00 18.00

Thanks,
Harvey
Providence,RI

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()