In step 2, after you converted the range to table and added the new column(Month_Money), then you can put the formula in the 1st empty cell. The formula will apply to the whole column automatically. The formula itself is : =CONCAT(MONTH([@[Date Closed]]),"_",[@[Buyer wire in / Seller Wire Out / Wire Out]]). I hope this helps!
Great video. How do I apply the excel formula? the video was too quick to show the steps.
In step 2, after you converted the range to table and added the new column(Month_Money), then you can put the formula in the 1st empty cell. The formula will apply to the whole column automatically. The formula itself is : =CONCAT(MONTH([@[Date Closed]]),"_",[@[Buyer wire in / Seller Wire Out / Wire Out]]). I hope this helps!
Is so fantastic! But the video was too quickly.
Thanks for your feedback! We'll try to improve to make it slower. If you have any questions, please let us know. Thanks!