I wish to stack columns with "OPERATOR" and "VALUE" where i repeat "NAME" like shown in the dummy sheet.
Is there a smart way of doing this with formula or maybe VBA?
Please advice
I wish to stack columns with "OPERATOR" and "VALUE" where i repeat "NAME" like shown in the dummy sheet.
Is there a smart way of doing this with formula or maybe VBA?
Please advice
One way (of many):
Formula:Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Seems to work but when I copy it into another spreadsheet I get unsupported function?
Go to your account page in Excel. What VERSION NUMBER of O365 do you have. It's a 4 digit number... 2202 or whatever.
I have Excel version 2202
OK. You don't have VSTACK. About to have my evening meal. I'll respond in about 2 hrs.
Try this instead:
Formula:Please Login or Register to view this content.
Okay, that seems to work! Could you quickly explain how I now can change this to do this for 500 columns?
I fiddled with it a bit to make adjustment easier.
Formula:Please Login or Register to view this content.
Just change the bits in red to match your data.
That worked, thank you! Really appreciate all your help Glenn
Hi,
I have tested this a bit more now and see that it stops stacking at column AA. How can I get it to carry on stacking until column RW?
Please Login or Register to view this content.
Please attach a file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks