Transpose data

[#1]

Hi All,

I have teh date as given below in excel .

Bankid	4/1/2015	4/2/2015	4/3/2015	4/4/2015	4/5/2015	4/6/2015
1171556	85	135	0	0	37	33
1193366	547	467	0	0	0	309
1194820	408	446	0	132	0	388
1195227	495	641	0	0	0	0
1202500	465	452	110	0	0	172
1206780	484	345	87	0	0	0

But the data needs to be captures in 3 columns ( Bank ID , Date, Marcount)

for ex

Bank ID	Date	Mar count
1171556	4/1/2015	85
1171556	4/2/2015	135
1171556	4/3/2015	0
1171556	4/4/2015	0
1171556	4/5/2015	37
1171556	4/6/2015	33

[#2]

It works Thanks

[sunny_talwar]

Awesome

I am glad it worked for you.

Best,

Sunny