Forum Discussion

weijin19792810's avatar
weijin19792810
Copper Contributor
Apr 10, 2018

How to combine few columns data into 1

May I know what functions I can do to combine the few columns data into 1. I need to get the data into 1 column highlighted in yellow.

 

 

Excel
    • weijin19792810's avatar
      weijin19792810
      Copper Contributor
      Apr 11, 2018

      Hi, 

       

      What I meant was to bring the data in G2, H4, I8, to the cell address of G12, H12 and I12. Thanks

       

      Actually, I have more than 1 student. I have around 50 students but I am just using 1 as example. 

      • Gourab Dasgupta's avatar
        Gourab Dasgupta
        Iron Contributor
        Apr 15, 2018

        hi

        create a sample excel file, with the result manually inputted. and mark the output cell. upload it I will follow you. thanks. 

Resources