Unanswered

Copying Data to another excel format

(0) Share

Report

Posted on by Manasabs9876

Hi All,

I have excel with the below details, Would want to have the transformed output as mentioned, please can someone guide what are the steps can be followed in power automate to get the output.

ID	Employee Name	02-01-2023	09-01-2023	16-01-2023	23-01-2023	30-01-2023	06-02-2023	13-02-2023	20-02-2023
1	ABC	1	2	6	5	1
2	XYZ						4	5	3

Output

ID	Employee Name	Month	Week 1	Week 2	Week 3	Week 4	Week 5
1	ABC	Jan	1	2	6	5	1
2	XYZ	Feb	4	5	3

All responses (4)

Answers (0)

AlexEncodian 4,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Copying Data to another excel format

@Manasabs9876

Do you have to use Power Automate? You could transform the data in excel although it would require several steps using index match and weeknum functions.
Manasabs9876 6 on at

Like (0)

Report

Re: Copying Data to another excel format

Hi @Nived_Nambiar
Any suggestions?
Manasabs9876 6 on at

Like (0)

Report

Re: Copying Data to another excel format

Hi @Nived_Nambiar
It's cloud flow
Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

Re: Copying Data to another excel format

Hi @Manasabs9876

Are you trying to do it in cloud flow or in desktop flow ?