Forum Discussion
Automatizing a process - automatically populating a cells
Hi Everyone,
I'm trying to automatize a process where with the data from excel file i have created a Power BI dashboard.
Long story short, I have one column "Column 5" where it's copying the data from another column "Column 2". I'm using the following formula =IF(G2<>"", G2, "")
The whole data in the excel file comes through automated flow, when form is submitted through Microsoft Forms it's populating the fields. The issue here is, when there is a new answer, Column 5 is not copying the data automatically from Column 2 but i have to drag the formula manually the whole time. If i enter a new answer manually then it's copying it automatically.
Is there a way that Column 5 can automatically copy the data from Column 2 without manually dragging the formula?
- Use BYROW() or MAP() function. Like =BYROW(G2:G50000,LAMBDA(r,IF(r<>"", r, ""))).
- Use BYROW() or MAP() function. Like =BYROW(G2:G50000,LAMBDA(r,IF(r<>"", r, ""))).
