Measure for dates in columns

Hi, Anonymous 

You need to do some operations in the power query editor.

1. Select the two columns with empty headings, and then select merge columns.

2. After merging the first and second columns, select Transpose directly.

3. Add index column

4. Add the date column that was just lost in the conversion process.

5. Is this the output you expect?

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.