Table.TransformRows or Table.TransformColumns

[@alejandrahorvath]

Code from this video
TblTfrRows
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Custom1 = Table.TransformRows (Source, each Text.Replace([Reference], "Ch.", "Cheque " ))
in
Custom1
TblTfrCols
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Custom1 = Table.TransformColumns (Source, {
{"Reference", each Text.Replace(_, "Ch." , "Cheque " ) } ,
{"Amount", each _ * 1000000} })
in
Custom1

[@raimundojs9547]

Excellent! Thank you for sharing and ¡Feliz Año Nuevo!

[@alejandrahorvath]

Muchas gracias. It's my pleasure to share. Felíz Año Nuevo!!! 😊

[@ziggle314]

Nice job Alejandra. I had never even looked at Table.TransformRows before 😊 Thanks.

[@alejandrahorvath]

You’re very welcome Mark😊. Glad you liked it! Thanks for watching😊

[@iankr]

Muchas gracias, Alejandra. Very useful!

[@alejandrahorvath]

Por nada! I'm glad you found it useful! 😊

[@shivmantra1406]

Hi Alejandra. I recently came across your channel and you certainly do some amazing advanced solutions. Thank you very much. The only feedback I have after watching other presenters is that they say what the final solution would look like at the start of the video. It would be great if you can show that at the beginning. You rock!!

[@alejandrahorvath]

Welcome to my channel! Happy to know that you find it useful. 😊
Thank you very much for the great feedback, I appreciate it! 🙏
I'll keep in mind for future videos 😊

[@SamehRSameh]

Marvelous 🎉🎉as usual 🎉🎉

[@alejandrahorvath]

Thank you so much 😀 Glad you liked it! 😊

[@eduardomunoz2764]

wonderful thanks, Ale... Greetings

[@alejandrahorvath]

Thank you so much Eduardo!!! Un fuerte abrazo 😊

[@kebincui]

excellent❤

[@alejandrahorvath]

Glad you liked it! Thanks for watching😊

[@SamehRSameh]

I need more about this formula with if statement plz

[@alejandrahorvath]

Thanks for watching Sameh!😊