Combining multiple excel sheets corresponding to name

Question

Hello All,Looking for some help here. I have a large excel sheet with multiple names that repeat - simplified version here. This is my Sheet 2&nbsp;NameCat 1Cat 2Cat3Cat4Cat 5Cat 6M10000000M6000001M6000001M8000010M9010000M9000010M10103060M6124060M6124060M81011900M8103300M9212200M10010000M10000001&nbsp;Sheet 1 is arranged in this fashion. It has the first occurrence of the names in sheet 2&nbsp;M6000001M8000010M9010000M10000000&nbsp;I would like to use a code to automatically add the other occurrences added under the name category.&nbsp; Please note some repeat multiple times and some don't repeat at all.&nbsp;Expected output:NameCat 1Cat 2Cat3Cat4Cat 5Cat 6M6000001M6000001M6124060M6124060M8000010M81011900M8103300M9010000M9000010M9212200M10000000M10103060M10010000M10000001&nbsp;

harun24hr · Answer

giriokamat&nbsp;Try SORTBY() function.=SORTBY(Sheet2!A2:G15,--SUBSTITUTE(Sheet2!A2:A15,"M",""))&nbsp;&nbsp;

Forum Discussion

Combining multiple excel sheets corresponding to name

1 Reply

Resources

Name	Cat 1	Cat 2	Cat3	Cat4	Cat 5	Cat 6
M10	0	0	0	0	0	0
M6	0	0	0	0	0	1
M6	0	0	0	0	0	1
M8	0	0	0	0	1	0
M9	0	1	0	0	0	0
M9	0	0	0	0	1	0
M10	1	0	3	0	6	0
M6	1	2	4	0	6	0
M6	1	2	4	0	6	0
M8	1	0	11	9	0	0
M8	1	0	3	3	0	0
M9	2	1	2	2	0	0
M10	0	1	0	0	0	0
M10	0	0	0	0	0	1