how to arrange Horizontal data convert into vertical data

[GVN KUMAR]

Sir
my data generation in horizontal type data
name pan salary TDS data
B RADHA AHKXB5339G 61824 10000 01/01/2018
B RADHA AHKXB5339G 61824 10000 01/02/2018
B RADHA AHKXB5339G 61824 10000 01/03/2018

my required data designing sir
month month month
Name pan salary TDS salary TDS salary Tds
B RADHA AHKXB5339G 61824 10000 61824 10000 61824 10000

best suggestion formula or pivot table how to write sir in xls 2007 & 2016

 

[Hareesh_KLD]

Hi,
one of the solution is using OFFSET formula
***here names are fixed and total 12 names
in OFFSET formula for rows you can use 0,12,24,36,48... for Jan,Feb,Mar,Apr,May...

Check attached sheet (sheet1 H19:O31)

 

[GVN KUMAR]

amazing sir
it working sir fine thank you a lot sir
thank you very very very simple sir

 

[GVN KUMAR]

Thank you so much for your idea, for the easy solution you give, for your precious time waiting for us.

Hi,
one of the solution is using OFFSET formula
***here names are fixed and total 12 names
in OFFSET formula for rows you can use 0,12,24,36,48... for Jan,Feb,Mar,Apr,May...

Check attached sheet (sheet1 H19:O31)

 

[bosco_yip]

@GVN KUMAR,

Here is another formula option based on your original table

1] Try this copy across down dynamic single formula

2] In the current 3 months table example, you show us that you have max. 13 persons for each month

3] My formula designed that you can have max. 30 persons in the table for each month (under the Offset function)

Then

In J4, formula copied across right and all copied down :

=IFERROR(1/(1/VLOOKUP($I4,OFFSET($B$1,MATCH(LOOKUP("zzz",$J$3:K$3),$E:$E,0),,30,3),2+ISTEXT(J$3),0)),"")

Regards

 

[GVN KUMAR]

The solution to the problem of using 6 formulas for a single solution is amazing