Grouping in MS Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1013529%22%20slang%3D%22en-US%22%3EGrouping%20in%20MS%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013529%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3CBR%20%2F%3EI%20need%20to%20create%20a%20data%20in%20MS%20Excel%20of%20branches%20which%20come%20under%20a%20region%20in%20the%20following%20way%3A%3C%2FP%3E%3CP%3ESuppose%20I%20have%20A%20to%20Z%20branches%20in%20a%20region%20%26amp%3B%20I%20have%20to%20display%20figures%20of%20different%20parameters%2C%20say%20a%20to%20d%2C%20of%20these%20branches%20as%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E(supposing%20there%20are%20rows%20and%20columns%20in%20this%20body%20text)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20a%20figure1%20figure2%20figure3%3CBR%20%2F%3EA%20b%20figure1%20figure2%20figure3%3CBR%20%2F%3EA%20c%20figure1%20figure2%20figure3%3CBR%20%2F%3EA%20d%20figure1%20figure2%20figure3%3CBR%20%2F%3EB%20a%20figure1%20figure2%20figure3%3CBR%20%2F%3EB%20b%20figure1%20figure2%20figure3%3CBR%20%2F%3EB%20c%20figure1%20figure2%20figure3%3CBR%20%2F%3EB%20d%20figure1%20figure2%20figure3%3CBR%20%2F%3EC%20a%20figure1%20figure2%20figure3%3CBR%20%2F%3EC%20b%20figure1%20figure2%20figure3%3CBR%20%2F%3EC%20c%20figure1%20figure2%20figure3%3CBR%20%2F%3EC%20d%20figure1%20figure2%20figure3%3CBR%20%2F%3E.%3CBR%20%2F%3E.%3CBR%20%2F%3E.%3CBR%20%2F%3EZ%20a%20figure1%20figure2%20figure3%3CBR%20%2F%3EZ%20b%20figure1%20figure2%20figure3%3CBR%20%2F%3EZ%20c%20figure1%20figure2%20figure3%3CBR%20%2F%3EZ%20d%20figure1%20figure2%20figure3%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHow%20can%20I%20approach%20this%20in%20excel%3F%20All%20figures%20are%20to%20be%20fetched%20using%20vlookup%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1013529%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi,
I need to create a data in MS Excel of branches which come under a region in the following way:

Suppose I have A to Z branches in a region & I have to display figures of different parameters, say a to d, of these branches as:


(supposing there are rows and columns in this body text)

 

A a figure1 figure2 figure3
A b figure1 figure2 figure3
A c figure1 figure2 figure3
A d figure1 figure2 figure3
B a figure1 figure2 figure3
B b figure1 figure2 figure3
B c figure1 figure2 figure3
B d figure1 figure2 figure3
C a figure1 figure2 figure3
C b figure1 figure2 figure3
C c figure1 figure2 figure3
C d figure1 figure2 figure3
.
.
.
Z a figure1 figure2 figure3
Z b figure1 figure2 figure3
Z c figure1 figure2 figure3
Z d figure1 figure2 figure3


How can I approach this in excel? All figures are to be fetched using vlookup function.