Format Problem

[AVG123]

Hello Friends.........

Today i was working on a list (excel sheet attached)........ it has 200 employees data (it may be 2000 employees depends on the list)........

It has two list 1. List (it contains actual data) and 2. Output Sheet.............
Please download my excel sheet and see the Output sheet....... i want my data's output like Output Sheet.........please tell me how can i format list like Output Sheet............


Thanks

[Pepe Le Mokko]

Still using XL2010?

[windknife]

Try this,

A2
=INDEX(List!A:A,INT((ROW()-2)/49)*98+MOD(ROW()-2,49)+2)&""

copied to D200 (according to what you want)

F2
=INDEX(List!A:A,INT((ROW()-2)/49)*98+49+MOD(ROW()-2,49)+2)&""

copied to I200

[AVG123]

Still using XL2010?

Excel 2021

[Pepe Le Mokko]

Please adapt your profile. Thx