Hi,
How to merge several columns into one column by placing the aligned rows from each column below each other. For example, the below columns A, B, and C...
A B C
book1 table1 door1
book2 table2 door2
book3 table3 door3
book4 table4 door4
... must result into the following single column:
book1
table1
door1
book2
table2
door2
book3
table3
door3
book4
table4
door4
Many thanks!
Gabriele
Try this Macro
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Many thanks for the solution! It does work.
Best,
Gabriele
Hi Gabriele,
If you had a newer version of Excel, and installed the*free Excel tool called "Power Query", you could do this problem using the "UnPivot" columns tool. You*would simply select all 3 columns and click on UnPivot.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Here's a formula method...
Data Range
This formula entered in E2:
=IFERROR(INDEX(A$2:C$5,CEILING(ROWS(E$2:E2)/3,1),3-MOD(ROWS(E2:E$12),3)),"")
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tony,
many thanks for another method. It does work too!
Best,
G
Originally Posted by MarvinP
Hi MarvinP,
Unfortunately I work with an older version of Excel. But thanks for advice. I did learn something new. The Power Query tool looks such a great addition to Excel!
Best,
Gabriele
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks