I have a dataset which I like to repeat the information in one row. I tried to use unpivot but it didnt work. Does anyone know how to make it?
Use the “Repeat rows” action before unpivoting.
It gives me the error below.
Example.xlsx (9.8 KB)
attached is the sample file. what I need to do is I need to show every category repeated based on the count for each month in a format shown above . Thanks
I was wrong. “Repeat rows” should be used after unpivoting. Here you go.
unpivot-generate.morph (3.9 KB)
Thank you. it worked.