Easy Office
LCI Learning

Excel

This query is : Resolved 
Profile Image

Profile Image

(Querist)
05 November 2011 there are 2000 rows of numbers in two columns ,i want to split into 100's in side by side of the column, is it possible with a formula
Profile Image

Ram Avtar Singh

Profile Image

Ram Avtar Singh (Expert)
05 November 2011 Copy data 100 which you want to split in column and select pastspecial then select transpose.

you will find as you want.

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries



Live Budget News and Updates

Trending Online Classes

view all classess
Let's Talk Money: You've Worked Hard for It, Now Make It Work for You
Click here for more bestsellers


Answer Query



Quick Links