Hi Jason,
thank you for your response...
i am a novice unfortunately to excel... I have this huge 1200 rouws of data which I need to delimit with rows as in the example above.
can you please assist me on how to create a pivot table?
many thanks in advance :)
Hi,
I have rows of data like below
Animal horse
Animal cat
Animal dog
Bird eagle
Bird pigeon
Car hyundai
Car swift
Car merc
Car BMW
Mobile iPhone
Mobile S4
I want to insert a yellow color coded row between each group so that each group can be distinguished easily
Like yellow...