Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

When a row of data is to be converted into columns

A) Copy the cells in row, select the same number of cells in columns and paste

B) Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

C) Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click

OK

D) Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark

Transpose check box and click OK

user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2015/05/17
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

Right clik Copy then right click and choose transpose the fourth option under paste 

Vina Sankaranarayanan
by Vina Sankaranarayanan , Operation Executive , BNY Mellon PVT LTD

Answer is------------- option B)

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

B) >>>>>>>>>>>>>Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

Bijumon Chandrahasan
by Bijumon Chandrahasan , Sr. Payroll and Compensation Officer , TRICONSTRUCT WLL - QATAR

B) Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

Deleted user
by Deleted user

B) .............................. is the correct answer

a) copy the cells in row,select the same number of cells in columns and paste

Deleted user
by Deleted user

Copy the range of cells in a row , go to the cell where you want to paste data,right click on that cell  select tarnspose option or  press 'ctrl+alt+ v' then select transpose & then press enter....

More Questions Like This