#Learnwitheasy FULL EXPLAINED SKIP BLANKS & TRANSPOSE FUNCTION IN MICROSOFT EXCEL IN URDU / HINDI 2021 STEP FOR TRANSPOSE " Step 1: Select blank cells. First select some blank cells. ... Step 2: Type =TRANSPOSE( With those blank cells still selected, type: =TRANSPOSE( ... Step 3: Type the range of the original cells. Now type the range of the cells you want to transpose. ... Step 4: Finally, press CTRL+SHIFT+ENTER. Now press CTRL+SHIFT+ENTER. SKIP BLANKS: The Skip blanks feature in Excel allows us to copy a data range with blank cells and paste the data within another area without overwriting the existing data with blanks CREDIT:GOOGLE.COM