How to union multiple columns in a new table

[ScripTeapot_]

I need help to order this data in a new table; I made a mock data to exemplify how they gave me the data.

The thing is, in january a certain amount of clients were charged for a number of day of service but they not necessarily paid in january. The same for the charged period of february and march. I need to order all the payment columns and all the dates columns into one column for each one; all the jan dates and amount first, the feb next and so on. Also, I need to identify from what month charged is. Like the next example:

The amount of clients may differ one month from another, so a need the blank spaces to see who has not paid.

I need this data in a new table to visualize correctly.

[tamerj1 · Accepted solution]

Hi @ScripTeapot_ 

Better to use poerr query to unpivot these columns. The column headers will become attributes in the Attribute column and the values will be in the Value column 

[ScripTeapot_]

I already try this, but it didn't work. I try unpivot the payment columns but the dates interact in a strange way. I had a similar case a few months ago but I don't know why it does not work now.

[tamerj1]

@ScripTeapot_ 
Then split it into 3 queries each one Date and one Value column then append the 3 queries.