Hi, I think there must be an easy way to do this!
I have several columns and two rows of data, so for example:
ABC DEF GHI JLK
123 456 789 101112
and I want to transpose it into one column like this
123
ABC
456
DEF
789
GHI
101112
JLK
I have tried a pivot table, however I need the numbers first then the letters, (in alphabetical order). Its not as easy as just using the copy and paste transpose functions, so there must be some sort of formula??!!
Thanks
Hi ciannyb and welcome to the forum,
Do your rows always go in pairs? Do you have only two rows of data in the worksheet?
If you attach a sample workbook, it is much easier for us to help with your problem.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi there!
The rows are in pairs, and yes there are only rows of data in the whole worksheet (but 54 columns!)
Thanks
Sorry, only two rows in the whole worksheet
Hi ciannyb,
Find the attached that has two formulas to do what you want. Copy the yellow cell formulas (using both at the same time) down column A and you will get what you want. Then Copy and Paste using Values Only so you can then delete the top rows.
Rows to Columns Indirect Address Pairs.xlsx
Another way
Enter in A4 and copy down
Formula:
Please Login or Register to view this content.
v A B C D E F G 1 ABC DEF GHI JKL GGG OPO DDDD 2 123 456 789 10 25 17 16 3 4 123 5 ABC 6 456 7 DEF 8 789 9 GHI 10 10 11 JKL 12 25 13 GGG 14 17 15 OPO 16 16 17 DDDD 18
Here is also non-volatile formula
Formula:Please Login or Register to view this content.
Last edited by AlKey; 09-28-2017 at 12:19 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
MarvinP - Tremendous!
That worked brilliantly, thanks so much.
Ciannyb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks