— CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 2 —
(Excel formulas also welcome)
Extract all alphabets in one column and numbers in another column.
For PQ (not for Excel formulas) - Make sure that query is dynamic i.e. if number of rows and columns increase/decrease, the query should give right result.
(Post answers in Comment)
Download Practice File - https://lnkd.in/deDK2wpV
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks
Excel BI LinkedIn Post