Restructure Data for Waterfall Chart

[mvmn]

New user here....

How can i pivot data in such a way that waterfall chart has 2019-2023 by account?  Thanks!

My data (as an example) looks like this...

Account	Description	Group	2019	2020	2023
100000	M&R	Production	500	500	800
200000	Salary	Operations	1000	25	25
300000	Burden	Sales	200	300	400
400000	Contractor	Unified	100	100	100
500000	Taxes	Territory	200	200	200
600000	Licensing	Etc.	400	500	500

Would like to look like this

Account	Description	Group	Value	Year
100000	M&R	Production	500	2019
200000	Salary	Operations	1000	2019
300000	Burden	Sales	200	2019
400000	Contractor	Unified	100	2019
500000	Taxes	Territory	200	2019
600000	Licensing	Etc.	400	2019
100000	M&R	Production	500	2020
200000	Salary	Operations	1000	2020
300000	Burden	Sales	200	2020
400000	Contractor	Unified	100	2020
500000	Taxes	Territory	200	2020
600000	Licensing	Etc.	400	2020
100000	M&R	Production	800	2023
200000	Salary	Operations	25	2023
300000	Burden	Sales	400	2023
400000	Contractor	Unified	100	2023
500000	Taxes	Territory	200	2023
600000	Licensing	Etc.	500	2023

[tarunsingla · Accepted solution]

Select first 3 columns and click Unpivot other columns.

Gives you this:

Regards,

Tarun

[mvmn]

Thanks @tarunsingla  this did it!