Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
It works Thanks
Awesome
I am glad it worked for you.
Best,
Sunny