Data Cleansing

[Raj008]

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....

[AngelosPachis · Accepted solution]

Hi @Raj008 ,

Would that work in your occasion?

Cheers,

Angelos

[Raj008]

Hi Angelos,

Actually I need 6 headers

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

Thanks...

[Qiu]

@Raj008 

Credits still goes to @AngelosPachis 

[Raj008]

Hi Qiu,

Can i have the full workflow with your input with Angelos.

Thanks...

[Qiu · Accepted solution]

@Raj008 

So sorry.

I must have forgot to save...