LinkBack URL
About LinkBacks
ctrapper 
Could someone explain the easiest way to do this.. I can't seem to find the answer..
I have almost 800 rows on a sheet
The data is in Columns A through B
A B
1 X Y
2 A B
What I need to read Col A and B horizontal not vertical
A B C
1 x
2 Y
Could someone explain the easiest way to do this.. I can't seem to find the answer..
I have almost 800 rows on a sheet
The data is in Columns A through B
A B
1 X Y
2 A B
What I need to read Col A and B horizontal not vertical
A B C
1 x
2 Y
HI ctrapper,
Check out "transpose" in xl help file. It doea what you are looking for.
Dave H
- Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
- Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
Hi Dave.. I tired the Transpose, but couldn't get it in the right format.. it took the data horizontal, but it's still not what I need..
What I need to do, and it would take forever manually, is insert a new row between each existing row, then take what's in Col B in the above row and move it into Col A in the newly created blank row.. trying to find a way to manually do that.. or if I could just figure out a way for EXCEL to insert multiple blank rows, I could use a formula to move the data down..
Can you post an example sheet showing before and after with a small portion of data. May be better able to help with this.
Dave H
A-D is the current formatting.. the info to the right in Col K is how I would like to appear..
See what you think of the attached. I can populate it all for you if you want but for now have just done the first bit. Once you are happy just copy and paste special values. The helper column can then be removed.
Dave H
No.. that's awesome. I can handle from here.. thanks.. !!! marking as solved!
Apologies ctrapper,
The sheet contained an error. I have now applied the indirect formula to the other two columns.
Original was scipping "Code" & "Date"
Dave H
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks