create list

2 posts / 0 new
Last post
Robert van den ...
Offline
Joined: 08/08/2018 - 07:37
create list

Hi, i want to analyse a dataset with a number of financial statements elements and periods. The problem i have is that for the analysis i need for every element all the periods. But the source file sometime doesn't have a mutation in a period.
How do i create this:

Financial statement element
Period

creditors
2019-Q1

creditors
2019-Q2

creditors
2019-Q3

creditors
2019-Q4

debtors
2019-Q1

debtors
2019-Q2

debtors
2019-Q3

debtors
2019-Q4

 
From this:

Financial statement element

creditors

debtors

 

Period

2019-Q1

2019-Q2

2019-Q3

2019-Q4

 
For each financial statement element i need to add all periods. I hope somone has any idea. 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Robert, any chance you can share some data?  I think a pivot table would work here for you but it is hard to tell without seeing how the data is set-up.