Transpose sets of columns

[c_raviram]

Hi Experts,

I have an attached sheet Input table which consist of quantity and value$.

Column with the date format as YYYY-MM-DD have quantity, whereas columns with date format as $ MMM-YY have values$.

Total 48 columns (2 years X 12 months X 2 measures(quantity and value))

Those 48 columns need to be transposed to 4 columns below (Month, year, Quantity and value) in the attached sheet Output

I know this can be achieved with two transpose tools but I am curious to know any alternative approach (combination of developer tools and transpose)

Problem with transpose tool is that sometimes it automatically deselect certain columns and hence a need to configure transpose tool again (for every cycle run).

Regards, Ravi

[Jean-Balteryx]

Hi @c_raviram ,

Transpose tool shouldn't deselect columns. Have you selected the "Dynamic or Unknown columns" option in Data columns ?

[c_raviram]

Hi Jean, yes upon deselection of "Dynamic or Unknown columns", the problem of auto deselection does not occur. I have posted a question to know any alternative approach for this exercise.

[Jean-Balteryx]

I think your approach is the best in your case !

[atcodedog05 · Accepted solution]

Hi @c_raviram 

Here is how you can do it.

Workflow:

I don't think its possible without transpose though.

Hope this helps : )

[c_raviram]

Thanks @atcodedog05 . Really appreciate.

Regards, Ravi