How to combine few columns data into 1

Copper Contributor

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.

 

 

3 Replies

HI

go through the attached file.

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. 

hi

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