Discussion Re: Excel - Moving two columns of data into one column of data in Excel
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621939#M109546
Ok, thank you for helping. I am trying to get one column of information to split between two columns. The 1st and 3rd are the same types of numbers and the 2nd and 4th are the same types of numbers and so on. I have a large amount of data. I figured out how to get the first set of information to work but not the second.<BR />In the example above I can get 17-329X, 2017-1072X, 2017-1233X and 17-1362X to go in column C but I get mixed information in column D when trying to get the Vxxx information. I used formula =INDEX($A:$A,3*ROW()-2) to work for column C but it doesn't work for column D. All information is coming from column A. I have tried different things to get a formula to work for column D but it only works if I manually change it. For example I enter =INDEX($A:$A,3*ROW()-1) and I get the information I want. I have to then change the 1 in each formula in the next cell down to the next number, 2,3,4 etc.<BR />Not sure if this helps you help me or not. I appreciate the thought and help though. <LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI><BR /><BR />Jhall212<BR /><BR /><BR /><BR />Fri, 06 Aug 2021 20:47:35 GMTJhall2122021-08-06T20:47:35ZExcel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2620221#M109480
<P>I need to move two columns of data into one column of data. The second column needs each cell to go under the corresponding row cell next to it. Is this possible? See example below please. </P><P> </P><P>1 a</P><P>2 b</P><P>3 c</P><P>4 d</P><P> </P><P>1</P><P>a</P><P>2</P><P>b</P><P>3</P><P>c</P><P>4</P><P>d</P><P> </P><P>Thanks, Jhall212</P><P> </P>Fri, 06 Aug 2021 14:46:47 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2620221#M109480Jhall2122021-08-06T14:46:47ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2620492#M109488
<P><LI-USER uid="1122277"></LI-USER> </P>
<P>Let's say the data are in A1:B4.</P>
<P> </P>
<P>In D1, enter the formula</P>
<P> </P>
<P>=INDEX($A:$B,QUOTIENT(ROW()-1,2)+1,MOD(ROW()-1,2)+1)</P>
<P> </P>
<P>and fill down.</P>Fri, 06 Aug 2021 15:39:19 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2620492#M109488Hans Vogelaar2021-08-06T15:39:19ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621401#M109522
<P><LI-USER uid="127945"></LI-USER> </P><P> </P><P>Thank you so much! Do you know how to move items from one column into two columns?</P><P> </P><P>Example:</P><P> </P><P>1</P><P>A</P><P> </P><P>2</P><P>B</P><P> </P><P>3</P><P>C</P><P> </P><P>4</P><P>D</P><P> </P><P>TO:</P><P>1 A</P><P>2 B</P><P>3 C</P><P>4 D</P><P> </P><P>Thanks!</P><P>Jhall212</P><P> </P>Fri, 06 Aug 2021 18:28:04 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621401#M109522Jhall2122021-08-06T18:28:04ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621536#M109529
<P><LI-USER uid="1122277"></LI-USER> </P>
<P>Let's assume that your data are in column A, starting in A1.</P>
<P> </P>
<P>Enter the following formula in C1:</P>
<P>=INDEX($A:$A,3*ROW()-2)</P>
<P>And in D1:</P>
<P>=INDEX($A:$A,3*ROW()-1)</P>
<P> </P>
<P>Select C1 and D1, then fill or copy down.</P>Fri, 06 Aug 2021 19:06:01 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621536#M109529Hans Vogelaar2021-08-06T19:06:01ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621645#M109532
It worked for cells A1 and A2 but then it skips cell A3 and goes to A4. It skips every third cell.<BR /><BR />1A<BR />B3<BR />4D<BR />5EFri, 06 Aug 2021 19:25:37 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621645#M109532Jhall2122021-08-06T19:25:37ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621688#M109535
<P><LI-USER uid="1122277"></LI-USER> </P>
<P>The way you posted the sample data makes it difficult to know what they really look like.</P>
<P>Could you attach a sample workbook?</P>Fri, 06 Aug 2021 19:45:30 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621688#M109535Hans Vogelaar2021-08-06T19:45:30ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621707#M109536
17-329X<BR />V33897360X<BR />2017-1072X<BR />V92921408X<BR />2017-1233X<BR />V55931648X<BR />17-1362X<BR />V11924954X<BR /><BR />17-329X V33897360X<BR />2017-1072X V92921408X<BR />2017-1233X V55931648X<BR />17-1362X V11924954X<BR /><BR />Fri, 06 Aug 2021 19:52:07 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621707#M109536Jhall2122021-08-06T19:52:07ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621924#M109543
<P><LI-USER uid="1122277"></LI-USER> </P>
<P>I'm afraid that doesn't help.</P>Fri, 06 Aug 2021 20:37:29 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621924#M109543Hans Vogelaar2021-08-06T20:37:29ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621939#M109546
Ok, thank you for helping. I am trying to get one column of information to split between two columns. The 1st and 3rd are the same types of numbers and the 2nd and 4th are the same types of numbers and so on. I have a large amount of data. I figured out how to get the first set of information to work but not the second.<BR />In the example above I can get 17-329X, 2017-1072X, 2017-1233X and 17-1362X to go in column C but I get mixed information in column D when trying to get the Vxxx information. I used formula =INDEX($A:$A,3*ROW()-2) to work for column C but it doesn't work for column D. All information is coming from column A. I have tried different things to get a formula to work for column D but it only works if I manually change it. For example I enter =INDEX($A:$A,3*ROW()-1) and I get the information I want. I have to then change the 1 in each formula in the next cell down to the next number, 2,3,4 etc.<BR />Not sure if this helps you help me or not. I appreciate the thought and help though. <LI-EMOJI id="lia_slightly-smiling-face" title=":slightly_smiling_face:"></LI-EMOJI><BR /><BR />Jhall212<BR /><BR /><BR /><BR />Fri, 06 Aug 2021 20:47:35 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621939#M109546Jhall2122021-08-06T20:47:35ZRe: Excel - Moving two columns of data into one column of data
https://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621986#M109551
I found a work around. I am using the filter feature instead. The numbers for each sequence I need have similar letters in them so I am using them to differentiate between my two columns. Thank you for the assist for the other formulas though, much appreciated!!Fri, 06 Aug 2021 20:59:46 GMThttps://techcommunity.microsoft.com/t5/excel/excel-moving-two-columns-of-data-into-one-column-of-data/m-p/2621986#M109551Jhall2122021-08-06T20:59:46Z