create list

Robert van den…

Forums

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 Thu, 06/11/2020 - 07:25

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.