same text in row need coloum wise

[sharadmaxwell]

i can write in words what i want
so i attached screen shot
one is data and another one is what is want
please guide


data

data.JPG

and following solution i want

want.JPG

Also attached herewith excel file

[shukla.ankur281190]

Excel 2016 (Windows) 64 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Drawer	Drawee Bank	Inst. No.		Drawer	Drawee Bank	Inst. No.1	Inst. No.2	Inst. No.3	Inst. No.4	Inst. No.5	Inst. No.6	Inst. No.7	Inst. No.8	Inst. No.9	Inst. No.10
2	AADYASREE ENTERPRISES	1000001343	395448		AADYASREE ENTERPRISES	1000001343	395448	395450
3	AADYASREE ENTERPRISES	1000001343	395450		ADARSHA HOSIERIES - BANGALORE	1000000331	409787	409788	649474	649480	649521
4	ADARSHA HOSIERIES - BANGALORE	1000000331	409787		ANJANADRI MARKETING	1000001458	208342	208344
5	ADARSHA HOSIERIES - BANGALORE	1000000331	409788		ARIHANT ENTERPRISE - CHENNAI	1000000416	068900
6	ADARSHA HOSIERIES - BANGALORE	1000000331	649474		B L TEXTILE	1000001373	042307
7	ADARSHA HOSIERIES - BANGALORE	1000000331	649480		B M ENTERPRISES - ERNAKULAM	1000000380	075225	075230	077624	077625
8	ADARSHA HOSIERIES - BANGALORE	1000000331	649521
9	ANJANADRI MARKETING	1000001458	208342
10	ANJANADRI MARKETING	1000001458	208344
11	ARIHANT ENTERPRISE - CHENNAI	1000000416	068900
12	B L TEXTILE	1000001373	042307
13	B M ENTERPRISES - ERNAKULAM	1000000380	075225
14	B M ENTERPRISES - ERNAKULAM	1000000380	075230
15	B M ENTERPRISES - ERNAKULAM	1000000380	077624
16	B M ENTERPRISES - ERNAKULAM	1000000380	077625

Sheet: Sheet1

E2

Please Login or Register  to view this content.

Copy across F column.

G2

Please Login or Register  to view this content.

[/FORMULA]

Copy across as far Inst No need

[sharadmaxwell]

Thanks a Lot shukla.ankur281190
it works great
thank you very much