Hi All, How do i convert the below data Instruments 2021 Feb 1 2021 Feb 2 2021 Feb 3 2021 Feb 4 2021 Feb 5 to Instruments 2021 2021 2021 2021 2021 Feb Feb Feb Feb Feb 1 2 3 4 5 Thanks in advance....

Data Cleansing

Hi All,

How do i convert the below data

Instruments

2021
Feb
1

2021
Feb
2

2021
Feb
3

2021
Feb
4

2021
Feb
5

Instruments 2021 2021 2021 2021 2021
Feb Feb Feb Feb Feb
1 2 3 4 5

Thanks in advance....

Datasets

Would that work in your occasion?

Cheers,

Angelos

So sorry.

I must have forgot to save...

Would that work in your occasion?

Cheers,

Angelos

Hi Angelos,

Actually I need 6 headers

Instruments 2021 Feb 1 2021 Feb 2 2021 Feb 3 2021 Feb 4 2021 Feb 5

Thanks...