Any excel experts?

priyashinde

priyashinde

Junior Member
Joined
Sep 5, 2017
Messages
103
Reaction score
7
already doen google,also not much payable

I have ecel sheet with 40 row and single column
want to convert first 3 cells to column
next 3 cells to second row

plz help
 
Advertise on BHW
it totally transposes
I want only first rows
 
Select the row and transpose it so it is a column. You can copy it and under past options select transpose.
On a new worksheet put this in the starting cell
=INDIRECT("Sheet2!R" & (COLUMN()-1)*3+MOD(ROW()-1,33)+1 & "C1", FALSE)
drag it down 3 then across as many times as needed. Change sheet2 to whatever sheet the transposed column is on.

You can then copy and paste values to get as text instead of formula.
 
Hello, google kutools, it is addon to excel, it makes similar operations very simple. I use it almost every day.
 
SamLewis said:
Select the row and transpose it so it is a column. You can copy it and under past options select transpose.
On a new worksheet put this in the starting cell
=INDIRECT("Sheet2!R" & (COLUMN()-1)*3+MOD(ROW()-1,33)+1 & "C1", FALSE)
drag it down 3 then across as many times as needed. Change sheet2 to whatever sheet the transposed column is on.

You can then copy and paste values to get as text instead of formula.
Click to expand...
I found this solution in google also
but not helpfull
 
all people in BHW are very helpful, your profile pic is a female but im sure your not
 
send ur excel sheet with mentioned what u want in details - I will forward with the details how to resolve the problems.
 
are you sorted yet? if not send me pm with link to file

actually

put this in cell
c1 =INDIRECT("r"&(3*ROW())-2&"c1",FALSE)
d1 =INDIRECT("r"&(3*ROW())-1&"c1",FALSE)
e1 =INDIRECT("r"&3*ROW()&"c1",FALSE)

this is for data without headers and pull formula down

again, will only work without headers data should start at cell A1
 
Last edited:
ashleyallsop said:
are you sorted yet? if not send me pm with link to file

actually

put this in cell
c1 =INDIRECT("r"&(3*ROW())-2&"c1",FALSE)
d1 =INDIRECT("r"&(3*ROW())-1&"c1",FALSE)
e1 =INDIRECT("r"&3*ROW()&"c1",FALSE)

this is for data without headers and pull formula down

again, will only work without headers data should start at cell A1
Click to expand...
will check
thanks
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top