Skip to Content
0
Former Member
Jun 11, 2014 at 07:13 AM

How we run loop for clubbing rows and then convert into column

23 Views

My requirement is:

in my internal table ittab1 for single date there are more than one entries corresponding to different agency no.

Date code Value

18.03.2012 02 2.22

18.03.2012 03 0.22

17.02.2012 02 0.12

17.02.2012 04 1.19

17.02.2012 03 2.21

.

.

.

I want to create another internal table in which I want for one date there is only a single row by converting row entries into columns.

pls suggest how I run loop to achieve the below internal table.

Internal Table name : ittab2

Date 01 02 03 04 05 .......

18.03.2012 2.22 0.22

17.03.2012 0.12 2.21 1.19

Thanks,

Samiksha.