• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

ack... any Excel expert?

1.) copy the cells you want in the row

2.) select the correct amount of cells in your row

3.) right click, select "paste special"

4.) check transpose

5.) ask in software forum next time

6.) ...?

7.) PROFIT

I'm sure someone has already beaten me to the punch.
 
you know you can also drag and drop cell contents...w/o copying and pasting..

simply click in the selected cell's wall, and the cursor turns into a 4-way move arrow thing...and just drag it to the cell you want
 
are the items seperated by an exact number of columns?

if that is the case... set your B column for B1=A1, B2=A(1+x)
C column for C1=A2, C2=A(2+x)... and so on

Then fill I think that should work. Since the columns are by reference only. Then you would highlight the B...whatever columns and copy and past them into another sheet.
 
Originally posted by: junkerman123
1.) copy the cells you want in the row

2.) select the correct amount of cells in your row

3.) right click, select "paste special"

4.) check transpose

5.) ask in software forum next time


I'm sure someone has already beaten me to the punch.
Click to expand...

You win....

 
Originally posted by: Juice Box
you know you can also drag and drop cell contents...w/o copying and pasting..

simply click in the selected cell's wall, and the cursor turns into a 4-way move arrow thing...and just drag it to the cell you want
Click to expand...

but that mean I will still have to do that 700 times...


The "tranpose" way works, but I still have to deleted the empty rows where the "Street Address", "City, State, Zip Code" and "Phone Number" used to reside.

plus, I still have to repeat 700 times to "tranpose" each entry.

can I tranpose all 700 in one time?
 
Originally posted by: andylawcc
Originally posted by: Juice Box
you know you can also drag and drop cell contents...w/o copying and pasting..

simply click in the selected cell's wall, and the cursor turns into a 4-way move arrow thing...and just drag it to the cell you want
Click to expand...

but that mean I will still have to do that 700 times...


The "tranpose" way works, but I still have to deleted the empty rows where the "Street Address", "City, State, Zip Code" and "Phone Number" used to reside.

plus, I still have to repeat 700 times to "tranpose" each entry.

can I tranpose all 700 in one time?
Click to expand...

With ms excel, either you do it right the first time, or you spend hours correcting it.
 
Originally posted by: DaShen
are the items seperated by an exact number of columns?

if that is the case... set your B column for B1=A1, B2=A(1+x)
C column for C1=A2, C2=A(2+x)... and so on

Then fill I think that should work. Since the columns are by reference only. Then you would highlight the B...whatever columns and copy and past them into another sheet.
Click to expand...

yes, I tried that too. but some Entry has 4 rows while some has 5. That screw up all the whole format. Beside, I still have to delete the Empty rows, entry by entry.
 
Fire up the VBA macro editor. If your text data has a consistent format it is a trivial matter to write a little loop to move the cells around.
 
Originally posted by: Kyteland
Fire up the VBA macro editor. If your text data has a consistent format it is a trivial matter to write a little loop to move the cells around.
Click to expand...

ya... I've been playing around with Macros right now for the very first time (not the programmable VBA ones though). The results are futile; and I am deciding should I continue to spend more time to find the quick solution, or just suck it up and cut-paste them in the old fashion way.
 
Originally posted by: andylawcc
yes, I tried that too. but some Entry has 4 rows while some has 5. That screw up all the whole format. Beside, I still have to delete the Empty rows, entry by entry.
Click to expand...
That 4 vs 5 is the biggest problem. Do they have consistant blanks between the rows? That is do the 4 row entries have 3 blanks and the 5 row entries have 2 blacks? If there is any consistency at all, I can show you how to do this easilly. If not, manual fixing or programming yourself will be the easiest solution. This would be a piece of cake to write your own code to solve though if you have any programming experience.

 
Originally posted by: dullard

That 4 vs 5 is the biggest problem. Do they have consistant blanks between the rows? That is do the 4 row entries have 3 blanks and the 5 row entries have 2 blacks? If there is any consistency at all, I can show you how to do this easilly. If not, manual fixing or programming yourself will be the easiest solution. This would be a piece of cake to write your own code to solve though if you have any programming experience.
Click to expand...


the one with "4"s have 2 rows of blanks. so does the "5"s. So they are consistant in that matter.

I was thinking sorting it manually, and take out the "4 row with 2 blanks" ones (these are minority.

right now, I am doing the "B2 = A3, C2 = A4, D2 = A5" way.

and no, I don't have any programming exps.
 
ah! I got it. It's not the most thorough way. but it simplified quite a bit.

I add a blank row to all the "4s" so all entry are consistant.

now, I used the "B2=A2, C2=A3, D2=A4" way and paste all the way to the end.


after that, I will still have to deleted the empty rows though...
 
Originally posted by: andylawcc
ah! I got it. It's not the most thorough way. but it simplified quite a bit.

I add a blank row to all the "4s" so all entry are consistant.

now, I used the "B2=A2, C2=A3, D2=A4" way and paste all the way to the end.


after that, I will still have to deleted the empty rows though...
Click to expand...
You are partly there.

1) Add the blank rows.
2) Use those formulas (or the transpose function).
3) Select ALL cells in the block from B1-F7.
4) Copy.
5) Select the cells below that block to paste into.
6) Paste.
7) Select the columns B-F.
8) Sort.

No deleting of empty rows, and only one paste needed.
 
Originally posted by: dullard
Originally posted by: andylawcc
ah! I got it. It's not the most thorough way. but it simplified quite a bit.

I add a blank row to all the "4s" so all entry are consistant.

now, I used the "B2=A2, C2=A3, D2=A4" way and paste all the way to the end.


after that, I will still have to deleted the empty rows though...
Click to expand...
You are partly there.

1) Add the blank rows.
2) Use those formulas (or the transpose function).
3) Select ALL cells in the block from B1-F7.
4) Copy.
5) Select the cells below that block to paste into.
6) Paste.
7) Select the columns B-F.
8) Sort.

No deleting of empty rows, and only one paste needed.
Click to expand...

ya! I am done. 🙂

Thanks alot of guys.... all of you. 🙂



oh, if anyone wants a list of Chinese Restaurant in the Bay Area, I am glad to email it to you 🙂
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top