I'm struggling to find out how to rearrange my data in Excel. My data set looks like this:
A B C D etc.
date1 20.000 5.000 0 0
date2 0 0 0 30.000
date3 0 10.000 10.000 0
etc.
where date(i) represents the date of my cash flows and A,B,C,D are the different types of cash flows. Since this dataset has lots of columns, I'd like to rearrange the data by increasing the number of rows when there is more than one flow in date(i). So the output is supposed to be this one:
Cash Flow Type
date1 20.000 A
date1 5.000 B
date2 30.000 D
date3 10.000 B
date3 10.000 C
etc.
Any tips on how to get what I want? Cheers
