Hi Team,
I have uploaded power query to excel and I have to add some more columns back at the left.
If I added those columns at the right, the table extended dynamically. However it is not extending to the left as I required.
Please kindly have a look my working and let me know.
thank you.
Regards,
Aye
Hi Aye,
That's because these columns are not part of the Table, so they don't automatically copy down. I would move these columns to Power Query. You really should only use external columns when there's no other choice.
Mynda
Hi Mynda,
Thanks for your reply.
Can I get the similar or equivalent formulae in power query for =IF(E2=E1, IF(F2=F1, A1, (A1+1)), 1).
If there is one in Power query, can you please direct me the chapter to revise.
Thank you.
Regards,
Aye
Many thanks, Mynda.
This is great.
Regards,
Aye
