Hi,
My aim to be achieved is when there are 3 items under each of the 2 groups in excel for example,
+Work
Data1
Data2
Data3
+Name
Name1
Name2
Name3
I want it in the following way with a new column beside the items filled with group name;
+Work
Data1 Work
Data2 Work
Data3 Work
+Name
Name1 Name
Name2 Name
Name3 Name

The above is just an example. The no. of items under each group and no. of groups vary.

Thanks in advance,
Bhavana.