Converting single column into rows

[ArnabSengupta]

Hi All,

I have a dataset, where it gives sale of 3 product based on different months.

I want to convert the Months column into rows so products are not duplicated for each month.

I have attached an excel file to this and also sheet 2 contains the expected output.

Help is much appreciated

Thank you! 

[AkimasaKajitani]

Hi @ArnabSengupta 

I can't find the month column from your sample file.

But according to the Desired Output, I made the sample workflow.

Step is as follows.

1. I filled the empty value of "Order number" and "Product number" by using Multi-row formula.

2. I made the field of Make1~3 by using Tile tool.

3. After that, I used the Cross Tab into desired output.

Please check the attached workflow. If you have any question, let me know.

[ArnabSengupta]

Hi @AkimasaKajitani : I am sorry for the mishap, I uploaded a wrong file. I have updated it with the correct file. Kindly take a look into it.

Thank you!

[messi007 · Accepted solution]

@ArnabSengupta,

You can do this with cross tab tool.

Please see below:

Attached the workflow.

Hope this helps!

Regards

[HomesickSurfer]

Hi @ArnabSengupta 

Here's my approach that includes all calendar months, including those not present in your data(without sales), and; with columns in left-right order (Jan-Dec)...assuming that you will require that.

Workflow attached.

[atcodedog05]

Hi @ArnabSengupta 

Just adding another approach to the mix 🙂

Workflow:

Hope this helps : )

[ArnabSengupta]

Thank you all for helping me out on this.

Cheers!

[HomesickSurfer]

Hi @ArnabSengupta 

Did you not require columns for.months without sales, as per your sample output?

[Kamran1991 · Accepted solution]

You can use this also