Cosby wrote:I'm trying to construct a formula to populate specific text in a cell based on values in another cell but can't find the right one so any help appreciated. One column has dates in format dd/mm/yyyy and I want to populate the month only in text in a new column e.g. where mm = 01, populate January, etc. There might be an alternative way to resolve so open to any and all suggestions!
Facewon wrote:https://techcommunity.microsoft.com/t5/excel/turning-alternate-rows-into-columns-power-query-m-function/m-p/3047553#M127550
Help me.
Turning alternate rows into 2 columns, first row/column will be Name, second will be amount. I think I can get something with isodd/iseven but it'll be messy. Trying to work out a M function solution so I can keep it in PQ.
It looks like you're new here. If you want to get involved, click one of these buttons!