Dear Experts.
I have sequential Data in a Table. Need a Logic to have these Table date in one Single Coloum.
A2 B2 C2
A3 B3 C3
A4 B4 C4
Result in Coloum D to be as
A2
B2
C2
A3
B3
C3
so on .......
Please advise. Attached Sample.
Expert Advise Please. Thanks in Advance.
Welcome to the forum!
Attached is a Power Query solution.
Excel 2016 (Windows) 32 bit
Merged Mike 1130 15 Tiger 4585 23 Stark 8745 14 Stuart 1235 19 Henry 8569 45
Sheet: Sheet1
The M code:
Please Login or Register to view this content.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Alternatively, put this formula in E3:
=INDEX(A:C,INT((ROWS($1:1)-1)/3)+3,MOD(ROWS($1:1)-1,3)+1)
then copy down.
Hope this helps.
Pete
Thanks "AliGW" The PowerQuery Worked & Helped me to Develop additional Logic.
Thanks "Pete_UK" ....... Never Thought The INDEX function can be used as an Advanced Transpose Function. Thank You So Much for the Logic.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Hey Ali,
Instead of doing this problem with a Merge columns and then split I did it a little different.
My method is to Add a column, I use the Add Index only to get another column and then UnPivot the non-Index columns. We get the same answer but just a different method. See my steps...
Please Login or Register to view this content.
BTW - I bought that PQ book you suggested yesterday.. Just starting to read it.. Kindle version as it costs less..
Marv
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
It's a great book. I bought PDF and hard copy. Hope you find it useful!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks