transpose array

[Stuart3]

Hi,

I have a table:

Ref	Name	Comment
Ref1	Jo	abc
Ref2	Mary	def
Ref3	Mary	ghi

I would like to transpose it to

Name	Comment-Ref1	Comment-Ref2	Comment-Ref3
Jo	abc	null	null
Mary	null	def	ghi

My Flow is:

I've tried various ways but I've gone back to arrays. Could anyone help me please?

Thanks

S

[ManishJain]

Hi @Stuart3 ,

Please follow the url and see if it helps :

https://immersivecoder.com/2021/08/29/transpose-table-columns-using-power-automate-with-example/

Thanks

[Stuart3]

Hi Manish,

This was the only example I could find and it didn't work for my example.

I've tried that.

I'm surprised that transposing arrays don't seem to be commonly requested.

S

[ManishJain]

Hi @Stuart3 ,

Thanks for letting me know. Will get back to you soon.

Thanks

[Stuart3]

Hi @ManishJain ,

Are you able to help further?

Thanks

S