Enjoy life...

Unmerge all cells in column A and B Select all rows in column A and B from your first row of data to your last row of data. Press CTRL+G to open the Go To box Click Special Choose Blank Cells In the formula bar enter = then press the Up arrow. You'll end up with a formula like =A1. DO NOT PRESS ENTER Press CTRL+ENTER and this will populate your formula to all selected cells and simulate a "fill down". Copy-paste as values as required.

 Change default audio track of Video from Android itself! It is very annoying to select your desired audio track or language every time after playing a video.  Looking for a way to force play the audio track after playing the video? Here is the solution.  Download termux Follow steps for changing 'track 2' to default audio track. After downloading, type following commands in termux. pkg update && pkg upgrade pkg install ffmpeg -y termux-setup-storage   (android window will open. Search and allow termux for enabling storage access) cd /sdcard (file must be in internal storage) ls (this will give list of folders, navigate to folder containing video file) ffmpeg -i "name of your video file with extension" -map 0:v:0 -map 0:a:1 -map 0:a:0 -c copy "name of your output file with extension" Done!

Here’s a list of Loan Accounts that you might find on your Credit Report: Amazon Pay Later: CapFloat Financial Services / IDFC First Bank Ltd. / Karur Vysya Bank. Flipkart Pay Later: IDFC First Bank Ltd. PayTM Postpaid Lite: Clix Finance India Pvt. Ltd. PayTM Postpaid Delite: Aditya Birla Finance Ltd. OlaMoney Postpaid: Aditya Birla Finance Ltd. Mobikwik: IDFC First Bank Ltd. CRED Stash: IDFC First Bank Ltd. LazyPay: PayU Finance. Simpl: ICICI Bank. MPockket: Jalan Chemical Industries Pvt Ltd. Postpe: SBM Bank. Bharatpe: Hindon Mercantile. ZestMoney: InCred / DMI Finance / Nahar Slice: DMI Finance Private Limited Quadrillion Finance Private Limited Fairassets Technologies India Private Limited Aphelion Finance Private Limited Northern Arc Capital Limited Vivriti Capital Private Limited Freecharge Pay Later - Axis Bank. UniCard - NDXP (Northern Arc, DMI Finance, Liquiloans, Lendbox) StashFin - AKARACAPL. MoneyView - WHIZDM Finance. Red Carpet - DMI Finance. SI Creva Capital - Kissht Bra...

Here are some of the best SIP plans to consider for investment in 2023: Axis Long Term Equity Fund Canara Robeco Equity Tax Saver Fund Mirae Asset Tax Saver Fund Invesco India Tax Plan Fund DSP Tax Saver Fund Quant Tax Plan Bank of India Tax Advantage For a 1-year investment, some of the best SIP plans include: ICICI Prudential Short-Term Fund Baroda BNP Paribas Liquid Fund Sundaram Liquid Fund Mirae Asset Cash Management Fund For a 15-year investment, some of the best SIP plans include: Tata Digital India Fund ICICI Prudential Technology Fund Quant Infrastructure Fund Parag Parikh Flexi Cap Fund *Source: Internet search; Consult your financial adviser before investing, information provided here for educational purpose only.

 Go to desired transaction Input the variables (F9) Program --> Execute in background background print parameters --> properties immediate --> tick periodic job (F5) period values --> desired frequency (Ctrl+S) Save Go to transaction SM37 and select the job you want to download. Click on the Spool button. Select the spool request and click on the Display Contents button. From the System menu, select List > Save > Local File. Choose the Spreadsheet option and save the file.

To Download view only videos from sharepoint or teams, where only link sharing option is visible. Using Google Chrome => Chromium / (latest) Microsoft Edge / Safari should follow approximately the same flow. Open the  Sharepoint page  with the video you want to download Press  F12  or  Ctrl + Shift + C  on your keyboard to open the browser inspector. ( Cmd + Option + C  on Mac OS X) In the top part, click on the  Network  tab In the top left part - right below the Network tab - you should see a field with the word " Filter " inside it. Click it to gain focus and type:  manifest Refresh  the Sharepoint page After a few seconds you should now see  1 result in the browser inspector's network part . That should be something looking like: videomanifest?provider=spo...  => that right there is the manifest URL you will need later on.  Right-click on it and copy the link address . Step 7) The method I described in my ea...