I need to be able to transpose two columns that span throughout my entire sheet into just two columns.. I know I can do it with just transposing into a single column but I need it for both of them.. Any ideas?
I need to be able to transpose two columns that span throughout my entire sheet into just two columns.. I know I can do it with just transposing into a single column but I need it for both of them.. Any ideas?
It can be done (also 2 columns) with just copy => paste special => transpose.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
This is what happens with what you suggested.
Screenshot_2.png
I can't open th PNG.
You could better post an excel file, so forummembers don't have to rebuilt your file.
I tested it, and it will work.
Okay, this has the part number and then the quantity to the right of it. I just want two columns, the part number and quantity all the way down. Thanks.
column A and B transposed in row 31 and 32
See the attached file.
Yeah I get that you can transpose them into rows but I said in my first post that I wanted them all just transposed into two columns. That way I can filter it and select what I need from it.
Probably you are better off, with an VBA solution.
But I don't see how the data is related.
There is one column that is the part number the other column is the qty. This is repeated throughout the entire sheet. Each two groups of columns are a location where these part numbers are located. I just want them put all into two columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks