LinkBack URL
About LinkBacks
Hi all,
I want to arrange column from Horizontal to Vertical . Please help.
from :
V05001 SV05016 SV06016
QL QL CN
L XL XXL
L L XXL
L L XL
to:
V05001
QL
L
L
L
V05016
QL
XL
L
L
V06016
CN
XXL
XXL
XL
arrange.jpg
Hi all,
I want to arrange column from Horizontal to Vertical . Please help.
from :
V05001 SV05016 SV06016
QL QL CN
L XL XXL
L L XXL
L L XL
to:
V05001
QL
L
L
L
V05016
QL
XL
L
L
V06016
CN
XXL
XXL
XL
arrange.jpg
Last edited by thaimic; 07-04-2018 at 05:45 AM.
Hello,
Please attach sample file in future help.
Check here for your requirement: https://www.extendoffice.com/documen...ne-column.html
If you provide the sample file helps us to assit you in better way.
Regards,
Thangavel D
Appreciate the help? CLICK *
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Or you can use Power Query (Get & Transform Data), if you have a later version of Excel:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Profile says Excel 2007 ...
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yup. Other people (with later versions) might be interested in the alternate approach
I bet the OP is actually using a later version, too.
Probably - if so, he needs to update his profile!
PowerQuery is really useful and quick for this type of thing, but it's not intuitive when you first use it, so the OP (and others new to it) may require more of a helping hand with this solution.
Which would be a new question...Originally Posted by AliGW
We generally don't preface VBA answers with "Start by pressing Alt-F11, then click Insert > Module". When people do need led by the hand, there are existing resources / pointers to help. Same with Power Query, IMO.
No, there's no need to preface the answer with it, Olly, and I don't think that's what I said. I was thinking more of something like the VBA boilerplate text used by many here for those who do not know anything about VBA (e.g. "How to install your new VBA code."). However, whilst VBA has been around and established for a long, long time, PQ is relatively unknown and untested.
Anyway, let's not derail the thread.
Too late for that.
It is now ... !!!
"PQ For Dummies" link added to my signature...
Formula solution. Pl see file.
In A10 then drag down.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks