Changing data view from horizntal to vertical view

Question

May I ask for assist regarding the attached sheet.
If I have a list of units (B) that have dues in different dates (E) and different amounts (D) also I have the payments as described from column (I) To column (AU). Every payment including (clear date - amount - Receipt Number), then the calculated fieled (AY) and i need to organize these data to be easier for tracking (in vertical view not horizntal view).

if the above is applicable is there any way to separate the payments and link them with the dues

Thanks in advance

wildecoyote1966 · Answer

If you want to only see those columns just copy them to another tab. but use a formula and not copy and paste.

hussein_elsayed · Answer

Wildecoyote1966&nbsp;i need an idea to present the mentioned data to be like the attached

wildecoyote1966 · Answer

hussein_elsayed&nbsp;try using ='Detailes Installments'!B3on sheet 1 change the cell reference&nbsp;i did a hand full

Forum Discussion

Changing data view from horizntal to vertical view

3 Replies