Convert two matrices to one column in Excel VBA The Next CEO of Stack OverflowConvert one...
Why isn't the Mueller report being released completely and unredacted?
How to check if all elements of 1 list are in the *same quantity* and in any order, in the list2?
Is French Guiana a (hard) EU border?
Why does the flight controls check come before arming the autobrake on the A320?
What happened in Rome, when the western empire "fell"?
Reference request: Grassmannian and Plucker coordinates in type B, C, D
Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?
Math-accent symbol over parentheses enclosing accented symbol (amsmath)
Can a Bladesinger Wizard use Bladesong with a Hand Crossbow?
Unclear about dynamic binding
INSERT to a table from a database to other (same SQL Server) using Dynamic SQL
When you upcast Blindness/Deafness, do all targets suffer the same effect?
RigExpert AA-35 - Interpreting The Information
Why the difference in type-inference over the as-pattern in two similar function definitions?
Is there a way to save my career from absolute disaster?
Recycling old answers
How to count occurrences of text in a file?
Can we say or write : "No, it'sn't"?
Easy to read palindrome checker
What connection does MS Office have to Netscape Navigator?
What did we know about the Kessel run before the prequels?
Can MTA send mail via a relay without being told so?
What is the value of α and β in a triangle?
Should I tutor a student who I know has cheated on their homework?
Convert two matrices to one column in Excel VBA
The Next CEO of Stack OverflowConvert one column into multiple rowsHow to convert column data into rows, grouped by identifierVBA to move specific data from one column to anotherFrom column to matrixFill rows down quickly (column or matrix of zeros)how to convert table to one column (show ONLY what i mentioned in table shopping list)convert one column data to two column data in excelConverting one large column to several columnsConvert Excel data list to matrixHow to do minus operation in excel for matrix based on specific criteria
I have the following two matrices.
Matrix A:
$A=left( begin{matrix}
text{1} & text{2} & text{3} & text{4} & text{5} & text{6} \
text{2} & text{3} & text{4} & text{5} & text{6} & text{7} \
text{8} & text{9} & text{12} & text{18} & text{11} & text{13} \
text{14} & text{10} & text{17} & {} & {} & text{16} \
{} & text{15} & {} & {} & {} & {} \
end{matrix} right)$
Matrix B:
$B=left( begin{array}{*{35}{l}}
169 & 54 & 118 & 309 & 223 & 249 \
211 & 98 & 255 & 260 & 156 & 63 \
160 & 207 & 308 & {} & {} & 351 \
{} & 89 & {} & {} & {} & {} \
end{array} right)$
I want to convert the above two matrices into one column only in Excel VBA.
[c=left( begin{array}{*{35}{l}}
169 \
54 \
118 \
309 \
223 \
249 \
211 \
98 \
begin{align}
& 255 \
& begin{array}{*{35}{l}}
156 \
63 \
160 \
207 \
begin{align}
& 308 \
& 260 \
& 351 \
& 89 \
end{align} \
end{array} \
end{align} \
end{array} right)]
What formula can be used to perform this task?
microsoft-excel microsoft-excel-2010 vba programmers-notepad
edited 13 mins ago
karel
9,34493239
asked 5 hours ago
Math090Math090
63
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have the following two matrices.
Matrix A:
$A=left( begin{matrix}
text{1} & text{2} & text{3} & text{4} & text{5} & text{6} \
text{2} & text{3} & text{4} & text{5} & text{6} & text{7} \
text{8} & text{9} & text{12} & text{18} & text{11} & text{13} \
text{14} & text{10} & text{17} & {} & {} & text{16} \
{} & text{15} & {} & {} & {} & {} \
end{matrix} right)$
Matrix B:
$B=left( begin{array}{*{35}{l}}
169 & 54 & 118 & 309 & 223 & 249 \
211 & 98 & 255 & 260 & 156 & 63 \
160 & 207 & 308 & {} & {} & 351 \
{} & 89 & {} & {} & {} & {} \
end{array} right)$
I want to convert the above two matrices into one column only in Excel VBA.
[c=left( begin{array}{*{35}{l}}
169 \
54 \
118 \
309 \
223 \
249 \
211 \
98 \
begin{align}
& 255 \
& begin{array}{*{35}{l}}
156 \
63 \
160 \
207 \
begin{align}
& 308 \
& 260 \
& 351 \
& 89 \
end{align} \
end{array} \
end{align} \
end{array} right)]
What formula can be used to perform this task?
microsoft-excel microsoft-excel-2010 vba programmers-notepad
edited 13 mins ago
karel
9,34493239
asked 5 hours ago
Math090Math090
63
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
A matrix isn't a single column, you just want to use some special character to denote a new row or something? Or ignore the rows & columns, and just have a series of numbers?
– Xen2050
4 hours ago
yes the matrix is nxm Matrix A have the numbers for the rows for example in C row 1 then c1,1=169 row2 then c2,1=54 and so on
– Math090
4 hours ago
add a comment |
I have the following two matrices.
Matrix A:
$A=left( begin{matrix}
text{1} & text{2} & text{3} & text{4} & text{5} & text{6} \
text{2} & text{3} & text{4} & text{5} & text{6} & text{7} \
text{8} & text{9} & text{12} & text{18} & text{11} & text{13} \
text{14} & text{10} & text{17} & {} & {} & text{16} \
{} & text{15} & {} & {} & {} & {} \
end{matrix} right)$
Matrix B:
$B=left( begin{array}{*{35}{l}}
169 & 54 & 118 & 309 & 223 & 249 \
211 & 98 & 255 & 260 & 156 & 63 \
160 & 207 & 308 & {} & {} & 351 \
{} & 89 & {} & {} & {} & {} \
end{array} right)$
I want to convert the above two matrices into one column only in Excel VBA.
[c=left( begin{array}{*{35}{l}}
169 \
54 \
118 \
309 \
223 \
249 \
211 \
98 \
begin{align}
& 255 \
& begin{array}{*{35}{l}}
156 \
63 \
160 \
207 \
begin{align}
& 308 \
& 260 \
& 351 \
& 89 \
end{align} \
end{array} \
end{align} \
end{array} right)]
What formula can be used to perform this task?
microsoft-excel microsoft-excel-2010 vba programmers-notepad
edited 13 mins ago
karel
9,34493239
asked 5 hours ago
Math090Math090
63
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have the following two matrices.
Matrix A:
$A=left( begin{matrix}
text{1} & text{2} & text{3} & text{4} & text{5} & text{6} \
text{2} & text{3} & text{4} & text{5} & text{6} & text{7} \
text{8} & text{9} & text{12} & text{18} & text{11} & text{13} \
text{14} & text{10} & text{17} & {} & {} & text{16} \
{} & text{15} & {} & {} & {} & {} \
end{matrix} right)$
Matrix B:
$B=left( begin{array}{*{35}{l}}
169 & 54 & 118 & 309 & 223 & 249 \
211 & 98 & 255 & 260 & 156 & 63 \
160 & 207 & 308 & {} & {} & 351 \
{} & 89 & {} & {} & {} & {} \
end{array} right)$
I want to convert the above two matrices into one column only in Excel VBA.
[c=left( begin{array}{*{35}{l}}
169 \
54 \
118 \
309 \
223 \
249 \
211 \
98 \
begin{align}
& 255 \
& begin{array}{*{35}{l}}
156 \
63 \
160 \
207 \
begin{align}
& 308 \
& 260 \
& 351 \
& 89 \
end{align} \
end{array} \
end{align} \
end{array} right)]
What formula can be used to perform this task?
microsoft-excel microsoft-excel-2010 vba programmers-notepad
microsoft-excel microsoft-excel-2010 vba programmers-notepad
edited 13 mins ago
karel
9,34493239
asked 5 hours ago
Math090Math090
63
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 13 mins ago
karel
9,34493239
asked 5 hours ago
Math090Math090
63
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 13 mins ago
karel
9,34493239
edited 13 mins ago
karel
9,34493239
edited 13 mins ago
karel
9,34493239
9,34493239
asked 5 hours ago
Math090Math090
63
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 5 hours ago
Math090Math090
63
asked 5 hours ago
Math090Math090
63
63
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Math090 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
A matrix isn't a single column, you just want to use some special character to denote a new row or something? Or ignore the rows & columns, and just have a series of numbers?
– Xen2050
4 hours ago
yes the matrix is nxm Matrix A have the numbers for the rows for example in C row 1 then c1,1=169 row2 then c2,1=54 and so on
– Math090
4 hours ago
add a comment |
A matrix isn't a single column, you just want to use some special character to denote a new row or something? Or ignore the rows & columns, and just have a series of numbers?
– Xen2050
4 hours ago
yes the matrix is nxm Matrix A have the numbers for the rows for example in C row 1 then c1,1=169 row2 then c2,1=54 and so on
– Math090
4 hours ago
A matrix isn't a single column, you just want to use some special character to denote a new row or something? Or ignore the rows & columns, and just have a series of numbers?
– Xen2050
4 hours ago
A matrix isn't a single column, you just want to use some special character to denote a new row or something? Or ignore the rows & columns, and just have a series of numbers?
– Xen2050
4 hours ago
yes the matrix is nxm Matrix A have the numbers for the rows for example in C row 1 then c1,1=169 row2 then c2,1=54 and so on
– Math090
4 hours ago
yes the matrix is nxm Matrix A have the numbers for the rows for example in C row 1 then c1,1=169 row2 then c2,1=54 and so on
– Math090
4 hours ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Math090 is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1419455%2fconvert-two-matrices-to-one-column-in-excel-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Math090 is a new contributor. Be nice, and check out our Code of Conduct.
Math090 is a new contributor. Be nice, and check out our Code of Conduct.
Math090 is a new contributor. Be nice, and check out our Code of Conduct.
Math090 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1419455%2fconvert-two-matrices-to-one-column-in-excel-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
A matrix isn't a single column, you just want to use some special character to denote a new row or something? Or ignore the rows & columns, and just have a series of numbers?
– Xen2050
4 hours ago
yes the matrix is nxm Matrix A have the numbers for the rows for example in C row 1 then c1,1=169 row2 then c2,1=54 and so on
– Math090
4 hours ago